Hello, What is missing in that article is you must never use NOW without rounding it down in a filter query. If you have it, round it down to an hour, day or minute to prevent flooding the filter cache.
Regards, Markus -----Original message----- > From:Atita Arora <atitaar...@gmail.com> > Sent: Wednesday 29th May 2019 15:43 > To: solr-user@lucene.apache.org > Subject: Re: Very low filter cache hit ratio > > You can refer to this one: > https://teaspoon-consulting.com/articles/solr-cache-tuning.html > > HTH, > Atita > > On Wed, May 29, 2019 at 3:33 PM Saurabh Sharma <saurabh.infoe...@gmail.com> > wrote: > > > Hi Shwan, > > > > Many filters are common among the queries. AFAIK, filter cache are created > > against filters and by that logic one should get good hit ratio for those > > cached filter conditions.i tried to create a cache of 100K size and that > > too was not producing good hit ratio. Any document/suggetion about > > efficient usage of various caches and their internal working. > > > > Thanks > > Saurabh > > > > On Wed 29 May, 2019, 6:53 PM Shawn Heisey, <apa...@elyograg.org> wrote: > > > > > On 5/29/2019 6:57 AM, Saurabh Sharma wrote: > > > > What can be the possible reasons for low cache usage? > > > > How can I leverage cache feature for high traffic indexes? > > > > > > Your usage apparently does not use the exact same query (or filter > > > query, in the case of filterCache) very often. > > > > > > In order to achieve a high hit ratio on a cache, the same query will > > > need to be used by many users. That's not happening here. I'm betting > > > that each user is sending something unique to Solr - which means it will > > > be impossible to get a hit, unless that user sends the same query again. > > > > > > Thanks, > > > Shawn > > > > > >
