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