: Thanks for your suggestions. I did try the [NOW/DAY-7DAYS TO : NOW/DAY], but it is not better. And I tried [NOW/DAY-7DAYS TO : NOW/DAY+1DAY], I got some exception as below: : org.apache.solr.core.SolrException: Query parsing error: Cannot parse : 'account:1 AND recordeddate_dt:[NOW/DAYS-7DAYS TO NOW/DAY 1DAY]': : Encountered "1DAY" at line 1, column 57.
you need to propertly URL escape the "+" character as %2B in your URLs. : And I will try to open the cache and see if I can get better query time. the first request won't be any faster. but the second request will be. and if filtering by week is something you expect peopel to do a lot of, you can put it in a newSearcher so it's always warmed up and fast for everyone. -Hoss
