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?
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
((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 faster?
I can
-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
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:12Z TO
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 erickerick...@gmail.com wrote:
Hmmm, what does the rest of your query look like? And does adding
debugQuery=on show anything interesting?
Best