Hello Rajani. Which version are you running? IIRC 9.1.2 has some improvement about caching short queries.
On Sun, Apr 16, 2023 at 4:25 PM Rajani Maski <rajinima...@gmail.com> wrote: > 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 > -- Sincerely yours Mikhail Khludnev https://t.me/MUST_SEARCH A caveat: Cyrillic!
