Re: Disjuctive Queries (OR queries) and FilterCache

2013-11-08 Thread Erick Erickson
Glad to hear you have a solution Best, Erick On Thu, Nov 7, 2013 at 5:12 PM, Patanachai Tangchaisin < patanachai.tangchai...@wizecommerce.com> wrote: > Hi Erick, > > About the size of filter cache, previously we set it to 4,000. > After we faced this problem, we changed it to 10,000. > Stil

Re: Disjuctive Queries (OR queries) and FilterCache

2013-11-07 Thread Patanachai Tangchaisin
Hi Erick, About the size of filter cache, previously we set it to 4,000. After we faced this problem, we changed it to 10,000. Still at size of 10,000 (always full), hitratio was 0.78 and "eviction" was as high as "insertion". About 100% Cpu, yes, it was Solr using it. I profiled an app, it was

Re: Disjuctive Queries (OR queries) and FilterCache

2013-11-07 Thread Erick Erickson
Yeah, Solr's fq cache is pretty simple-minded, order matters. There's no good way to improve that except try to write your fq queries in the same order. It's actually quite tricky to disassemble/reassemble arbitrary queries to fix this problem. But in your case, you could write a custom query comp