You must show us the _exact_ filter queries you’re using, or at least a 
representative sample.

Bumping the cache up very high is almost always the wrong thing to do. Each 
entry takes approximately maxDoc/8 bytes so unless your corpus is very small, 
you’ll eventually blow memory up.

To Markus’ point about NOW, a full treatment is here: 
https://dzone.com/articles/solr-date-math-now-and-filter

Best,
Erick

> On May 29, 2019, at 6:47 AM, Markus Jelsma <markus.jel...@openindex.io> wrote:
> 
> 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
>>>> 
>>> 
>> 

Reply via email to