without having investigated the problem much i would think that a SQL database would be a very bad match for lucene as most of lucene's working is creating key's for words and documents and then creating indexes of these keys. for these purposes a SQL database is an unecessary overhead, not even talking about the overhead represented by the SQL language parser.
for these kind of indexes a lower-level database would be better suited. I have good experiences with BerkeleyDB (http://www.sleepycat.com) and a friend of me uses gdbm successfully for such key-pair indexing tasks. the advantage of these low-level databasesystems is that they are really much or less persistent b-tree/hashtable implementations, and thus created for key-pairing. they have no SQL layer as you will have to program against them as they are more subroutines that applications. but for key-pair indexes i have experienced that BerkeleyDB runs circles around any SQL database (including db2 and oracle!!!). Berkeley has a java-api and a b-tree record type that could be a very good match for a key-based searchtree, and it's free. take a look at it! mvh karl řie (ps: i am not payed by the sleepy cat to write this :-) On Wednesday 03 April 2002 16:12, you wrote: > If you want to store indices in a database search the mailing list > archives for SqlDirectory. > > Once I considered using it for one application at work, so I asked its > author about performance. The answer was that it doesn't perform all > that well when the index grows, if I recall correctly. Consequently, > we chose to use file-based indices instead. > > Otis > > --- [EMAIL PROTECTED] wrote: > > Hi all > > > > I want to index the datas which I already stored in a thirdparty > > database table and develop a search facility using lucene. I am > > thinking of storing this indexes back to the database in another > > table. I know for this we have to create a 'directory' which do all > > the indexing operations, > > > > for example > > > > Indexwriter indwriter = new Indexwriter("dirStore",null,create); > > > > where dirStore is the directory, create is boolean. > > > > but I don't know the format to be followed for the > > directory(dirStore).Please help me if anybody has done similar > > thing. > > TIA > > Amith > > > > > > __________________________________________________________________ > > Your favorite stores, helpful shopping tools and great gift ideas. > > Experience the convenience of buying online with Shop@Netscape! > > http://shopnow.netscape.com/ > > > > Get your own FREE, personal Netscape Mail account today at > > http://webmail.netscape.com/ > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > __________________________________________________ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>