Hi,
your QTimes are somewhat slow!
First: I am really surprised that the difference between explicit
Date-Values and the more friendly date-keywords is that large.
Did you made a server restart between both tests?
Second: Could you show us your solrconfig to make sure that your caches
are configured well?
How many documents are part of that test-index?
I suggest you to adjust the precisionStep-definition of your TrieDateField.
Furthermore: Take into consideration, whether you really need 500 rows
per request.
Kind regards,
Em
Am 21.02.2012 21:49, schrieb ku3ia:
> Hi, Em, thanks for your response. But seems a have a problem.
> I wrote a script, which sends a queries (curl based), with a certain delay.
> I had made a dictionary of matched words. I run my script with 500ms delay
> during 60 seconds. Take look at catalina logs:
>
> INFO: [] webapp=/solr path=/select
> params={fl=fileds_from_schema_here,score&sort=score+desc&start=0&q="baby"&wt=json&fq=Date:[2012-01-23T00:00:00Z+TO+2012-02-21T23:59:59Z]&rows=500}
> status=0 QTime=1735
> INFO: [] webapp=/solr path=/select
> params={fl=fileds_from_schema_here,score&sort=score+desc&start=0&q="girl"&wt=json&fq=Date:[2012-01-23T00:00:00Z+TO+2012-02-21T23:59:59Z]&rows=500}
> status=0 QTime=9794
>
> INFO: [] webapp=/solr path=/select
> params={fl=fileds_from_schema_here,score&sort=score+desc&start=0&q="baby"&wt=json&fq=Date:[NOW-30DAY+TO+NOW]&rows=500}
> status=0 QTime=13885
> INFO: [] webapp=/solr path=/select
> params={fl=fileds_from_schema_here,score&sort=score+desc&start=0&q="girl"&wt=json&fq=Date:[NOW-30DAY+TO+NOW]&rows=500}
> status=0 QTime=33995
>
> Note, that not all queries from the second test are slower, for example:
> INFO: [] webapp=/solr path=/select
> params={fl=fileds_from_schema_here,score&sort=score+desc&start=0&q="with"&wt=json&fq=Date:[2012-01-23T00:00:00Z+TO+2012-02-21T23:59:59Z]&rows=500}
> status=0 QTime=18645
>
> INFO: [] webapp=/solr path=/select
> params={fl=fileds_from_schema_here,score&sort=score+desc&start=0&q="with"&wt=json&fq=Date:[NOW-30DAY+TO+NOW]&rows=500}
> status=0 QTime=7877
>
> but in average I have:
> *** Date:[2012-01-23T00:00:00Z+TO+2012-02-21T23:59:59Z] ***
> Queries processed: 110
> Queries cancelled: 4
> Max QTime is: 22728 ms
> Avg QTime is: 6681.31 ms
> Min QTime is: ms
>
> *** Date:[NOW-30DAY+TO+NOW] ***
> Queries processed: 20
> Queries cancelled: 94
> Max QTime is: 45203 ms
> Avg QTime is: 39195.2 ms
> Min QTime is: ms
>
> I repeated this test more times - results seems equal. Is it true, that
> [2012-01-23T00:00:00Z+TO+2012-02-21T23:59:59Z] is faster than
> [NOW-30DAY+TO+NOW]
> ?
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Date-filter-query-tp3764349p3764781.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
