Re: Date granularity

2012-04-20 Thread Erick Erickson
Well, that's just the way Solr works. You can tune the range performance by playing with the prescisionStep, Trie fields are built to make range queries perform well. Best Erick On Fri, Apr 20, 2012 at 10:20 AM, vybe3142 wrote: > ... Inelegant as opposed to the possibility of using /DAY to speci

Re: Date granularity

2012-04-20 Thread vybe3142
... Inelegant as opposed to the possibility of using /DAY to specify day granularity on a single term query In any case, if that's how SOLR works, that's fine Any rough idea of the performance of range queries vs truncated day queries? Otherwise, I might just write up a quick program to compare t

Re: Date granularity

2012-04-20 Thread Erick Erickson
The only way to get more "elegant" would be to index the dates with the granularity you want, i.e. truncate to DAY at index time then truncate to DAY at query time as well. Why do you consider ranges inelegant? How else would you imagine it would be done? Best Erick On Thu, Apr 19, 2012 at 4:07

Re: Date granularity

2012-04-19 Thread vybe3142
Also, what's the performance impact of range queries vs. querying for a particular DAY (as described in my last post) when the index contains , say, 10 million docs ? If the range queries result in a significant performance hit, one option for us would be to define additional DAY fields when inde

Re: Date granularity

2012-04-19 Thread vybe3142
Thanks So , I tried out the suggestions. I used the main query though (not a filter) 1. Using a DATE range and DAYdoes give me the desired results. Specifically, the query that I used was 2. Without a DATE range, the parser seems to reduce the date to the beginning of the day i.e. 00:00:00 and a

Re: Date granularity

2012-04-18 Thread Erick Erickson
If Peter's suggestion doesn't work, please post the results of adding &debugQuery=on to your query. The date math stuff is sensitive to spaces, for instance and it's impossible to tell whether you're making a simple error like that without seeing what you're actually doing. Best Erick On Wed, Apr

Re: Date granularity

2012-04-18 Thread Peter Markey
you could use a filter query like: fq=datefield:[NOW/DAY-1DAY TO NOW/DAY+1DAY] *replace datefield with your field that contains the time info On Wed, Apr 18, 2012 at 11:11 AM, vybe3142 wrote: > A query search on a particular date: > > returns 1valid result (as expected). > > How can I alter the