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 <av...@checkpoint.com> wrote: > 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. >
