Hi Chris, Thank you very much for the detail suggestions. I just did the cache test. If most of requests return the same set of data, cache will improve the query performance. But in our usage, almost all requests have different data set to return. The cache hit ratio is very low. That's the reason we close the cache for memory saving. Another question is: q=account:1+AND+recordeddate_dt:[NOW/DAY-7DAYS+TO+NOW/DAY] will combine the resultset of account:1 and recordeddate_dt:[NOW/DAY-7DAYS+TO+NOW/DAY]. How lucene handle it? From my previous test examples, it seems lucene will not check the size of the subconditions (like account:1 or recordeddate_dt:[NOW/DAY-7DAYS+TO+NOW/DAY]). Q=account:1 will return a small set of data. But q=recordeddate_dt:[NOW/DAY-7DAYS+TO+NOW/DAY] will return a large set of data. If we combine them with "AND" like: q=account+AND+recordeddate_dt:[NOW/DAY-7DAYS+TO+NOW/DAY]. It should return the small set of data and then apply the subcondition "recordeddate_dt:[NOW/DAY-7DAYS+TO+NOW/DAY]". But from the response time, it seems not the case. Can anyone give me some detail explaination about this? Thank you very much. Yongjun Rong
-----Original Message----- From: Chris Hostetter [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2008 2:32 PM To: solr-user@lucene.apache.org Subject: RE: Search query optimization : 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
