lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Rochkind <rochk...@jhu.edu>
Subject RE: filter query on timestamp slowing query???
Date Fri, 23 Jul 2010 17:45:28 GMT

> and a typical query would be:
>
fl=id,type,timestamp,score&start=0&q="Coca+Cola"+pepsi+-"dr+pepper"&fq=timestamp:[2010-07-07T00:00:00Z+TO+NOW]+AND+(type:x+OR+type:y)&
> rows=2000

On top of using trie dates, you might consider separating the timestamp portion and the type
portion of the fq into seperate fq parameters -- that will allow them to to be stored in the
filter cache seperately. So for instance, if you include "type:x OR type:y" in queries a lot,
but with different date ranges, then when you make a new query, the set for "type:x OR type:y"
can be pulled from the filter cache and intersected with the other result set, that portion
won't have to be run again. That's probably not where your slowness is coming from, but shouldn't
hurt. 

Multiple fq's are essentially AND'd together, so whenever you have an 'fq' that's seperate
clauses AND'd together, you can always seperate them into multiple fq's, wont' effect the
result set, will effect the caching possibilities. 
Mime
View raw message