have a look for more background information: https://issues.apache.org/jira/browse/SOLR-8096
it's not only related to version 6.6. It's a question of design since 5.x Günter On 23.10.2017 21:06, John Davis wrote:
Hello, We are seeing really slow facet performance with new solr release. This is on an index of 2M documents. A few things we've tried: 1. method=uif however that didn't help much (the facet fields have docValues=false since they are multi-valued). Debug info below. 2. changing query (q=) that selects what documents to compute facets on didn't help a lot, except repeating the same query was fast presumably due to exact cache hits. Sample debug info: “timing”: { “prepare”: { “debug”: { “time”: 0.0 }, “expand”: { “time”: 0.0 }, “facet”: { “time”: 0.0 }, “facet_module”: { “time”: 0.0 }, “highlight”: { “time”: 0.0 }, “mlt”: { “time”: 0.0 }, “query”: { “time”: 0.0 }, “stats”: { “time”: 0.0 }, “terms”: { “time”: 0.0 }, “time”: 0.0 }, “process”: { “debug”: { “time”: 87.0 }, “expand”: { “time”: 0.0 }, “facet”: { “time”: 9814.0 }, “facet_module”: { “time”: 0.0 }, “highlight”: { “time”: 0.0 }, “mlt”: { “time”: 0.0 }, “query”: { “time”: 20.0 }, “stats”: { “time”: 0.0 }, “terms”: { “time”: 0.0 }, “time”: 9922.0 }, “time”: 9923.0 } }, "facet-debug": { "elapse": 8310, "sub-facet": [ { "action": "field facet", "elapse": 8310, "maxThreads": 2, "processor": "SimpleFacets", "sub-facet": [ {}, { "appliedMethod": "UIF", "field": "school", "inputDocSetSize": 476, "requestedMethod": "UIF" }, { "appliedMethod": "UIF", "elapse": 2575, "field": "work", "inputDocSetSize": 476, "requestedMethod": "UIF" }, { "appliedMethod": "UIF", "elapse": 8310, "field": "level", "inputDocSetSize": 476, "requestedMethod": "UIF" } ] } Thanks John
-- Günter Hipler Universität Basel | Universitätsbibliothek | Projekt swissbib Schönbeinstrasse 18-20 | 4056 Basel | Schweiz Tel +41 61 207 31 12 | Fax +41 61 207 31 03 E-Mail guenter.hip...@unibas.ch | http://www.ub.unibas.ch | https://www.swissbib.ch