Are you suggesting rewriting it like this ? fq=filter(fromfield:[* TO NOW/DAY+1DAY]&& tofield:[NOW/DAY-7DAY TO *] ) fq=filter(type:abc)
Is this a better use of the cache as supposed to fq=fromfield:[* TO NOW/DAY+1DAY]&& tofield:[NOW/DAY-7DAY TO *] && type:"abc" Thanks On Thu, May 5, 2016 at 12:50 PM, Ahmet Arslan <iori...@yahoo.com.invalid> wrote: > Hi, > > Cache enemy is not * but NOW. Since you round it to DAY, cache will work > within-day. > I would use separate filer queries, especially fq=type:abc for the > structured query so it will be cached independently. > > Also consider disabling caching (using cost) in expensive queries: > http://yonik.com/advanced-filter-caching-in-solr/ > > Ahmet > > > > On Thursday, May 5, 2016 8:25 PM, Jay Potharaju <jspothar...@gmail.com> > wrote: > Hi, > I have a filter query that gets documents based on date ranges from last n > days to anytime in future. > > The objective is to get documents between a date range, but the start date > and end date values are stored in different fields and that is why I wrote > the filter query as below > > fq=fromfield:[* TO NOW/DAY+1DAY]&& tofield:[NOW/DAY-7DAY TO *] && > type:"abc" > > The way these queries are currently written I think wont leverage the > filter cache because of "*". Is there a better way to write this query so > that I can leverage the cache. > > > > -- > Thanks > Jay > -- Thanks Jay Potharaju
