It's often a mistake to try to force Lucene to act like a database. Is it possible to just use the database for the join portion and Lucene for the text search?
Otherwise I agree with Developer Developer. You need to provide a higher level idea of *what* it is you're trying to accomplish to get good suggestions. Best Erick On Jan 8, 2008 7:23 AM, sachin <[EMAIL PROTECTED]> wrote: > > I need to write lucene query something similar to SQL self joins. > > My current implementation is very primitive. I fire first query, get the > results, based on the result of first query I fire second query and then > merge the results from both the queries. The whole processing is very > expensive. Doing this is very easy with SQL query as we need to just > write self join query and database do the rest for you. > > What is the best way of implementing the above functionality in lucene? > > Regards > Sachin > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >