The second query excludes documents matched by [* TO X], while the first query matches all documents.

Relative performance will depend on relative match count and the sort time on the matched documents. Sorting will likely be the dominant factor - for equal number of documents. So, it depends on whether starting with X excludes or includes the majority of documents, relative to whatever row_count might be.

Generally, you should only sort a small number of documents/results.

Or, consider DocValues since they are designed for sorting.

-- Jack Krupansky

-----Original Message----- From: Furkan KAMACI
Sent: Sunday, July 28, 2013 5:06 PM
To: solr-user@lucene.apache.org
Subject: Query Performance

What is the difference between:

q=*:*&rows=row_count&sort=id asc

and

q={X TO *}&rows=row_count&sort=id asc

Does the first one trys to get all the documents but cut the result or they
are same or...? What happens at underlying process of Solr for that two
queries?

Reply via email to