On 5/29/2019 7:33 AM, Saurabh Sharma wrote:
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.
In order to produce a cache hit, the query or filter must be identical in every way. Whitespace and all. And it must be identical after parts of it are substituted or expanded by Solr.
Take note of the reply you received from Markus Jelsma. The "NOW" keyword is replaced by a current timestamp with millisecond accuracy -- which effectively means that queries using NOW are always different and cannot produce a cache hit. Rounding the timestamp using NOW/HOUR or NOW/DAY, if that fits user requirements, can be one solution to that problem.
Be careful with defining a large filterCache. The memory requirements can become VERY extreme.
Thanks, Shawn
