Re: Searching over multiple indexes with 1:m relationship

2007-06-28 Thread Erick Erickson
Michael > -Ursprüngliche Nachricht- > Von: Erick Erickson [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 28. Juni 2007 16:09 > An: java-user@lucene.apache.org > Betreff: Re: Searching over multiple indexes with 1:m relationship > > > I do have an off-the-wall ques

Re: Searching over multiple indexes with 1:m relationship

2007-06-28 Thread Chris Lu
What you should do is denorm the 1:m relationships. Don't try to mimic the database. If you need to, you can keep the original 2 indexes and create a third one. -- Chris Lu - Instant Scalable Full-Text Search On Any Database/Application site: http://www.dbsight.net demo:

Re: Searching over multiple indexes with 1:m relationship

2007-06-28 Thread Erick Erickson
I do have an off-the-wall question.. Why have two indexes? There are, of course, good reasons, but they're things like size and speed. Where I'm going here is that Lucene does NOT require that all documents have the same fields. So it's perfectly reasonable to index heterogeneous data (or differi