Hi All, We have about 100 different fields and 1 million documents we indexed with Solr. Many of the fields are multi-valued, and some are numbers (for range search). We are expecting to perform solr queries contains over 30 terms and often the response time is well over a second. I found that the caches in Solr such as QueryResultCache and FilterCache does not help us much in this case as most of the queries have combinations of terms that are unlikely to repeat. An example of our query would look like:
field1:(02 04 05) field2:(01 02 03) field3:(02 03 04 06) ... My question is how can we improve performance of these queries? Does Lucene have to read the index file again if we first do a query containing the term field1:01 then a second query containing field1:02? If we have sufficient memory, is it possible to cache certain fields so that it does not need to read from index files at all? Hope someone could provide me some suggestions. Thanks, Larry He
