AW: Slow Date-Range Queries

2010-04-30 Thread Jan Simon Winkelmann
For now I need them, I will however most likely (as suggested by Ahmet Arslan), create another boolean field to get rid of them, just simply due to the fact that I am switching to Solr 1.4 frange queries. On the topic of frange queries, is there a way to simulate the date range wildcards here?

Re: Slow Date-Range Queries

2010-04-29 Thread Lance Norskog
Do you really need the *:* stuff in the date range subqueries? That may add to the execution time. On Thu, Apr 29, 2010 at 9:52 AM, Erick Erickson wrote: > Hmmm, what does the rest of your query look like? And does adding > &debugQuery=on show anything interesting? > > Best > Erick > > On Thu, Ap

Re: Slow Date-Range Queries

2010-04-29 Thread Erick Erickson
Hmmm, what does the rest of your query look like? And does adding &debugQuery=on show anything interesting? Best Erick On Thu, Apr 29, 2010 at 6:54 AM, Jan Simon Winkelmann < winkelm...@newsfactory.de> wrote: > > > ((valid_from:[* TO 2010-04-29T10:34:12Z]) AND > > > (valid_till:[2010-04-29T10:34

RE: Slow Date-Range Queries

2010-04-29 Thread Nagelberg, Kallin
-Original Message- From: Jan Simon Winkelmann [mailto:winkelm...@newsfactory.de] Sent: Thursday, April 29, 2010 4:36 AM To: solr-user@lucene.apache.org Subject: Slow Date-Range Queries Hi, I am currently having serious performance problems with date range queries. What I am doing, is validating

AW: Slow Date-Range Queries

2010-04-29 Thread Jan Simon Winkelmann
> > ((valid_from:[* TO 2010-04-29T10:34:12Z]) AND > > (valid_till:[2010-04-29T10:34:12Z TO *])) OR ((*:* > > -valid_from:[* TO *]) AND (*:* -valid_till:[* TO *]))) > > > > I use the empty checks for datasets which do not have a > > valid from/till range. > > > > > > Is there any way to get this any

Re: Slow Date-Range Queries

2010-04-29 Thread Ahmet Arslan
> I am currently having serious performance problems with > date range queries. What I am doing, is validating a > datasets published status by a valid_from and a valid_till > date field. > > I did get a performance boost of ~ 100% by switching from a > normal solr.DateField to a solr.TrieDateFie

Slow Date-Range Queries

2010-04-29 Thread Jan Simon Winkelmann
Hi, I am currently having serious performance problems with date range queries. What I am doing, is validating a datasets published status by a valid_from and a valid_till date field. I did get a performance boost of ~ 100% by switching from a normal solr.DateField to a solr.TrieDateField with