On 8/5/2013 7:13 AM, Steven Bower wrote: > So after re-feeding our data with a new boolean field that is true when > data exists and false when it doesn't our search times have gone from avg > of about 20s to around 150ms... pretty amazing change in perf... It seems > like https://issues.apache.org/jira/browse/SOLR-5093 might alleviate many > peoples pain in doing this kind of query (if I have some time I may take a > look at it).. > > Anyway we are in pretty good shape at this point.. the only remaining issue > is that the first queries after commits are taking 5-6s... This is cause by > the loading of 2 (one long and one int) FieldCaches (uninvert) that are > used for sorting.. I'm suspecting that docvalues will greatly help this > load performance?
I would handle this by using newSearcher events in the config to search for all documents (*:*) with your desired sort parameters. That way, the fieldcache will be pre-populated before the new searcher accepts any queries. The old searcher will continue to handle queries will this is happening. Be aware that this will increase your commit time, which might mean that you need to decrease your autowarmCount values on your Solr caches to compensate. If you have removed this section from your solrconfig.xml file, see the example config. Thanks, Shawn
