Re: Help in searching mutliple indices

2008-09-06 Thread beerbal
The main reason behind having one index per table is that the tables grow to be very big and we want to keep updating the index as the table gets modified (may be at specified intervals). So, if table A changes (row modified, added or deleted) we want this change to be reflected in the index and we

Re: Help in searching mutliple indices

2008-09-06 Thread Erick Erickson
Well, what is the higher-level task you're trying to accomplish? I have real trouble understanding why you're using Lucene at all. Especially because scoring will be irrelevant *between* searches, since they're going at completely different "documents". That is, there is no relation between the sco

Help in searching mutliple indices

2008-09-06 Thread beerbal
Hello, I am a newbie user of Lucene Java. I am trying to use Lucene to enable in search in my application. I am stuck a little in actual Search. I'm facing a design issue and want help from experts here. Here is my scenario: * I have 7-8 tables in the database and I create a separate index for ea