I do these kinds of queries all the time. I found that the fastest
performance for my collections (millions of documents) came from
subclassing Filter using the set of primary keys from the database to
make the Filter, and then doing the query with the
Searcher.search(query,filter) interface. I
: Thanks for your tips. I am trying to get a more thorough understanding
: why this would be better.
1) give serious consideration to just putting all of your data in lucene
for the purposes of searching. the intial example mentioned employees,
and salaries and wanted to search for employees