On Mon, Nov 12, 2012 at 8:39 PM, Aeroox Aeroox <aero...@gmail.com> wrote: > Hi folks, > > I have a solr index with up to 50M documents. A document contain 62 fields > (docid, name, location....). > > The facet count took 1 to 2 minutes with this params : > > http://XXXX.../select/?q=solr&; > version=2.2&start=0&rows=0&facet=true&facet.limit=6&facet.mincount=1&mm=3<-1&facet.field=schoolname_hl&facet.method=fc
It should hopefully just take that long the first time? How much time does it take to facet on the same field subsequent times? > And my cache policy : > > <filterCache class="solr.FastLRUCache" > size="4096" > initialSize="4096" > autowarmCount="4096"/> > > <queryResultCache class="solr.LRUCache" > size="5000" > initialSize="5000" > autowarmCount="5000"/> These are relatively big caches - consider reducing them if you can. Especially the filter cache, depending on what percent of the entries are bitsets. Worst case would be 50M / 8 * 4096 = 25GB of bitsets. > * i'm using solr 1.4 (LUCENE_36) > * 64GB Ram (with 60GB allocated to java/tomcat6) Reduce this if you can - it doesn't leave enough memory for the OS to cache the index files and can contribute to slowness (more disk IO). -Yonik http://lucidworks.com
