Ok. I'll try that. Meanwhile query on resultId is subsecond response. But the immediate next query for faceting takes 40+secs. The core has 185million docs and 63GB index size.
curl 'http://localhost:8983/solr/TestCollection_shard1_replica_t3/query?q=resultId:xxxxxxxxxxxxx&rows=0' { "responseHeader":{ "zkConnected":true, "status":0, "QTime":558, "params":{ "q":"resultId:xxxxxxxxxxxxx", "cache":"false", "rows":"0"}}, "response":{"numFound":943,"start":0,"numFoundExact":true,"docs":[] }} curl 'http://localhost:8983/solr/TestCollection_shard1_replica_t3/query?q=resultId:xxxxxxxxxxxxx&rows=0' -d ' json.facet={ categories:{ "type": "terms", "field" : "resultId", "limit" : 1 } }' { "responseHeader":{ "zkConnected":true, "status":0, "QTime":43834, "params":{ "q":"resultId:xxxxxxxxxxxxx", "json.facet":"{\n categories:{\n \"type\": \"terms\",\n \"field\" : \"resultId\",\n \"limit\" : 1\n }\n}", "cache":"false", "rows":"0"}}, "response":{"numFound":943,"start":0,"numFoundExact":true,"docs":[] }, "facets":{ "count":943, "categories":{ "buckets":[{ "val":"xxxxxxxxxxxxx", "count":943}]}}} -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html
