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 >
