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

Reply via email to