lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erick Erickson <erickerick...@gmail.com>
Subject Re: Slow date filter query
Date Tue, 31 May 2016 03:17:58 GMT
Oops, fat fingers.

see:
searchhub.org/2012/02/23/date-math-now-and-filter-queries/

If you're not re-using the _same_ filter query, you'll be better
off using fq={!cache=false}range_query

Best,
Erick

On Mon, May 30, 2016 at 8:16 PM, Erick Erickson <erickerickson@gmail.com> wrote:
> That does seem long, but you haven't provided many details
> about the fields. Are there 100 docs in your index? 100M docs? 500M docs?
>
> Are you using NOW in appropriately? See:
>
> On Fri, May 27, 2016 at 1:32 PM, Jay Potharaju <jspotharaju@gmail.com> wrote:
>> Hi,
>> I am running filter query(range query) on date fields(high cardinality) and
>> the performance is really bad ...it takes about 2-5 seconds for it to come
>> back with response. I am rebuilding the index to have docvalues & tdates
>> instead of "date" field. But not sure if that will alleviate the problem
>> because of high cardinality.
>>
>> Can I store the date as YYYYMMDD and run range queries on them instead of
>> date fields?
>> Is that a good option?
>>
>> --
>> Thanks
>> Jay

Mime
View raw message