Yonik, Just curious why does using enum improve the facet performance.
Furkan was faceting on a text field with each word being a facet value. I'd imagine that'd mean there's a large number of facet values. According to the documentation (http://wiki.apache.org/solr/SimpleFacetParameters#facet.method) facet.method=fc is faster when a field has many unique terms. So how come enum, not fc, is faster in this case? Also why use filterCache less? Thanks Andy --- On Fri, 6/4/10, Furkan Kuru <furkank...@gmail.com> wrote: > From: Furkan Kuru <furkank...@gmail.com> > Subject: Re: Faceted Search Slows Down as index gets larger > To: solr-user@lucene.apache.org, yo...@lucidimagination.com > Date: Friday, June 4, 2010, 11:25 AM > I am using 1.4 version. > > I have tried your suggestion, > > it takes around 25-30 seconds now. > > Thank you, > > > On Fri, Jun 4, 2010 at 5:54 PM, Yonik Seeley > <yo...@lucidimagination.com>wrote: > > > Faceting on a full-text field is hard. > > What version of Solr are you using? > > > > If it's 1.4 or later, try setting > > facet.method=enum > > > > And to use the filterCache less, try > > facet.enum.cache.minDf=100 > > > > -Yonik > > http://www.lucidimagination.com > > > > On Fri, Jun 4, 2010 at 10:31 AM, Furkan Kuru <furkank...@gmail.com> > wrote: > > > Hello, > > > > > > I have been dealing with real-time data. > > > > > > As the number of total indexed documents gets > larger (now 5 M) > > > > > > a faceted search on a text field limited by the > creation time, which we > > use > > > to find the most used word in all these text > fields, gets slow down. > > > > > > > > > query string: created_time:[NOW-1HOUR TO NOW] > facet.field=text > > > facet.mincount=1 > > > > > > the document count matching the query is around > 9000. > > > > > > > > > It takes around 80 seconds in a decent computer > with 4GB ram, quad core > > cpu > > > > > > I do not know the internal details of term > indexing and their counts for > > > faceting. > > > > > > Any suggestion for speeding up this query is > appreciated. > > > > > > Thanks in advance. > > > > > > -- > > > Furkan Kuru > > > > > > > > > -- > Furkan Kuru >