date query performance (TrieDate)

[sausarkar <sa...@ebay.com>]

we are experiencing performance issues with date range queries. We have
configured the date fields as following:

<fieldType name="tdate" class="solr.TrieDateField" precisionStep="8"
omitNorms="true" positionIncrementGap="0"/>

Our queries are rounded every minute:

qt=ads&debugQuery=false&fl=id,StartDt_t110,.......&fq=Status_i110:2&fq=StartDt_t110:{
NOW/MINUTE-150DAYS TO NOW/MINUTE-90DAYS }&start=0&rows=20

Index size - 10 million documents in Solr 4.1

Start of every minute we see the query speed to be about 10-12 seconds and
increases over time. Is there a solution for this.



--
View this message in context: http://lucene.472066.n3.nabble.com/date-query-performance-TrieDate-tp4038419.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: date query performance (TrieDate)

[Otis Gospodnetic <ot...@gmail.com>]

Hi,

What are your documents and queries like? What does your performance
monitoring tool say about various server, jvm, and solr metrics?

Otis
Solr & ElasticSearch Support
http://sematext.com/
On Feb 4, 2013 3:36 PM, "sausarkar" <sa...@ebay.com> wrote:

> When the query time jump to more than 10 seconds the linux load average
> spikes up to more than 100 in a 16 CPU machine. Any one has any
> suggestions?
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/date-query-performance-TrieDate-tp4038419p4038422.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>

Re: date query performance (TrieDate)

[sausarkar <sa...@ebay.com>]

When the query time jump to more than 10 seconds the linux load average
spikes up to more than 100 in a 16 CPU machine. Any one has any suggestions?



--
View this message in context: http://lucene.472066.n3.nabble.com/date-query-performance-TrieDate-tp4038419p4038422.html
Sent from the Solr - User mailing list archive at Nabble.com.