lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Grant Ingersoll <>
Subject Re: Filtering on two date fields simultaneously
Date Thu, 01 Oct 2009 15:01:17 GMT

On Sep 29, 2009, at 11:30 AM, Dragan Jotanovic wrote:

> Hi, I was thinking a long time how to implement this kind of
> functionality but couldn't figure out anything appropriate.
> In my lucene document, I have two date fields: start and end date.
> As a search input I have current date (NOW).
> I need to display all documents for which current date is between
> start and end dates.
> I know that this could be performed by two RangeQuery-es, ie.
> startDate:{19700101 to NOW} AND endDate:{NOW to 29990101}
> but since the index could be very large, performance would not be  
> very good.
> RangeFilter is not a good idea as well, since I would have to filter
> on two fields (or maybe it would with ChainedFilter?).
> Does anyone know which approach would be the best in this kind of
> situation, performance wise?

In Lucene 2.9, there is much better performance for range queries on  
numerics, you might try that.

Grant Ingersoll

Search the Lucene ecosystem (Lucene/Solr/Nutch/Mahout/Tika/Droids)  
using Solr/Lucene:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message