Re: Storing ranges on documents and searching all document with specific value included

2014-01-31 Thread Jack Krupansky
, 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 rec

Re: Storing ranges on documents and searching all document with specific value included

2014-01-18 Thread Erick Erickson
Well, assuming that your start version and end versions are a limited set of values, filter queries (fq clauses) would help you a lot here. Autowarming them would cause them to be available the first time they were used... Best, Erick On Sat, Jan 18, 2014 at 1:01 AM, Avner Levy wrote: > I have m

Storing ranges on documents and searching all document with specific value included

2014-01-17 Thread Avner Levy
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