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