lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Powers <>
Subject Re: lucene and database searching, keeping score
Date Fri, 02 Dec 2005 23:59:35 GMT
Instead of just putting the keys in the index, can you put all the data you
might be getting out to display to the user, or whatever the final thing is?
That's what we do.    Search on the id as you are, and then the hit has
documents that are loaded with all your final information instead of just
the keys.   It'll save you a db connection at result time.

On 12/2/05 3:03 PM, "George Abraham" <>

> All,
> I have created a Lucene index from data in a SQL Server db. When I conduct a
> Lucene search, I get back in the hits the primary key (WorkID) and the
> scores associated with the hits. Then using the list of WorkIDs, I query the
> database for the other associated information of the assets associated with
> the WorkIDs. Since this is a SQL query, it is independent of the Lucene
> scoring and the order is all screwed up. How do I then add the scores to the
> resultset returned from the database? Basically I would want to merge the
> resultset from Lucene with the resultset from the SQL query.
> Thanks,
> George

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message