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
