Hi, To further the discussion. Would the following detailed steps work:
1) do lucene query and get the hits (keyed by the database primary key, for example, employee id) 2) do database query and get the primary keys (i.e., employee id) for the result rows, ordered by primary key 3) merge the two sets of primary keys (for example, in memory two-way merge) and take the top k records 4) display the top k result rows Cheers, Jian On Sat, 15 Jan 2005 12:40:04 +0000, Peter Pimley <[EMAIL PROTECTED]> wrote: > sunil goyal wrote: > > >But can i do for instance a unified query where i want to take certain > >parameters (non-textual e.g. age < 30 ) from relational databases and > >keywords from the lucene index ? > > > > > > > When I have had to do this, I've done the lucene search first, and then > manually filtered out the hits that fail on other criteria. > > I'd suggest doing that first (as it's easiest) and then seeing whether > the performance is acceptable. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
