First of all, make sure you use docvalues for facet fields with many unique
values.
If that still does not help you can try the following.
My kollega Toke Eskildsen has made a huge improvement when faceting IF the
number of results in the facets are less than 8% of the total number of
documents.
Hello everyone.
I’m having problems with the performance of queries with facets, the temp
expend to resolve a query is very high.
The index has 10Millions of documents, each one with 100 fields.
The server has 8 cores and 56 Gb of ram, running with jetty with this
memory configuration: