Apologies, I missed deducing from the request url that you're already talking strictly about single-shard requests (so everything I was suggesting about shards.preference etc. is not applicable). "dvhash" is still worth a try though, esp. with `numFound` being 943 (out of 185 million!). Does this happen on a warm searcher (are subsequent requests with no intervening updates _ever_ fast?)?
On Fri, Feb 5, 2021 at 6:13 PM mmb1234 <m...@vmware.com> wrote: > 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 >