What does your actual query look like? Is it two range queries and an AND?
Also, you have spaces in your field names, so that makes it more difficult
to write queries since they need to be escaped.
-- Jack Krupansky
-----Original Message-----
From: Avner Levy
Sent: Saturday, January 18, 2014 1:01 AM
To: 'solr-user@lucene.apache.org'
Subject: Storing ranges on documents and searching all document with
specific value included
I have millions of documents with the following fields:
name (string), start version (int), end version (int).
I need to query efficiently all records which answers the query:
Select all documents where version >= "start version" and version<="end
version"
Running the above query took 50-100 ms while similar query by tagging each
version took only 15 ms.
My question is how efficient can Solr handle such queries? (since it isn't
classic FTS query)
Do I need to define something special in order to optimize performance?
Any alternate solutions will be welcomed.
The fields values / types can be changed if needed.
