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
You might want to look at DateMath, http://lucene.apache.org/solr/api/org/apache/solr/util/DateMathParser.html. I believe the default precision is to the millisecond, so if you afford to round to the nearest second or even minute you might see some performance gains. -Kallin Nagelberg -Ori

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