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" <[EMAIL PROTECTED]> wrote: > 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
