Hi Solr Users, What are your suggestions to improve star queries latencies? By star queries I mean "*:*" or single term queries having boost formulas (such as doc recency and many others) taking 10 or more seconds. It is a large collection with good compute resources, however I am guessing this may be because each shard has too many documents and I noticed per shard response time also is high.
Splitting shards could be an option however it is already an evenly distributed, composite router, 96 shards collection, I am concerned that more than 100 shards per collection can lead to exhaustively searching too many shards and aggregation issues. What are your thoughts? Can we make use of any caches, query result cache or other caches, in solr that allows warming up and persisting these queries results in ram, and that maybe helps reduce this query time? Thanks, Rajani
