Re: design: merging resultset from RDBMS with lucene search results

2008-02-14 Thread Erick Erickson
Another possibility is to do it backwards, it depends on how expensive the SQL query is I suppose. The idea would be to go ahead and to your SQL query *first*, then construct a Lucene Filter to use with your query using TermDocs/TermEnum. I'd guess (without knowing much about your problem space) t

RE: design: merging resultset from RDBMS with lucene search results

2008-02-13 Thread spring
twoch, 13. Februar 2008 18:44 > To: java-user@lucene.apache.org > Subject: Re: design: merging resultset from RDBMS with lucene > search results > > Hi, > > You might consider avoiding this problem altogether, by simply adding > the meta data to your Lucene index. Lucene

Re: design: merging resultset from RDBMS with lucene search results

2008-02-13 Thread John Byrne
Hi, You might consider avoiding this problem altogether, by simply adding the meta data to your Lucene index. Lucene can handle untokenized fields, which is ideal for meta data. It might not be as quick as the RDB, but you could perhaps optimize by only searching in the RDB when you only need