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