Solr facet multivalued field performance issues

Question

I'm having some huge performance issues with facet queries.

I have an index of more then 20, 000, 000 of documents. And i'm doing for every query faceting search on 6 multivalued fields.

I've set the facet.method to ENUM... This increased the performance but still is unacceptable. Where the QTIME take's literraly over 6 seconds. My index is getting bigger every day... with approximatly 50k of document per week

Can someone help me! Is there any solution ? I've check everything, read all the tips but none was usefull so far

Did someone hit this problem ?

I'm using solr 3.6

Answer 1

Check for SolrCaching#filterCache and Cache_hit_rate
Filter Queries uses Filter Cache and should be set accordingly for better performance of subsequent the filter queries.
Check the Cache statistics on the admin page for the hit ratio, if you see a low hit ratio means the cache is not being used. Fine tuning to a correct value would help improve the performance significantly.