Thanks a lot Yonik! Rounding makes sense. Is there a date math for the 'LAST_COMMIT'?
Peter. > On Tue, Aug 17, 2010 at 6:29 PM, Peter Karich <peat...@yahoo.de> wrote: > >> my queryResultCache has no hits. But if I am removing one line from the >> bf section in my dismax handler all is fine. Here is the line: >> recip(ms(NOW,date),3.16e-11,1,1) >> > NOW has millisecond resolution, so it's actually a different query > each millisecond. > You could either use a date literal instead of NOW, or use date math > to round the date and get a better cache hit ratio... like NOW/hour or > something. > > -Yonik > http://www.lucidimagination.com >
