[prev in list] [next in list] [prev in thread] [next in thread] 

List:       solr-user
Subject:    Re: How to improve the Solr "OR" query performance
From:       Toke Eskildsen <te () statsbiblioteket ! dk>
Date:       2013-07-03 12:10:38
Message-ID: 1372853438.6005.71.camel () te-prime
[Download RAW message or body]

On Wed, 2013-07-03 at 05:48 +0200, huasanyelao wrote:
> The response time for "OR" query is around 1-2seconds(the "AND" query is just about 30ms-40ms ).

The number of hits will also be much lower for the AND-query. To check
whether it is the OR or the size of the result set that is the problem,
please try and construct an AND-based query that hits about as many
documents as your slow OR query.

With an index size of just 9GB, I am surprised that you use sharding.
Have you tried using just a single instance to avoid the merge-overhead?

- Toke Eskildsen, State and University Library, Denmark

[prev in list] [next in list] [prev in thread] [next in thread]