There are impl in the contrib that do not need to retrieve the entire index from the db in order to query (there store blocks of files in the db, instead of blocks on disk).
I also developed an implementation that did not use blocks but rather a custom index persistence mechanism. There can be several advantages with this: 1. centralized/automated backup 2. db usually can perform more optimized caching of blocks 3. use multiple "nearly diskless" query servers with a single database 4. transactional updates to the index are possible (although index writes are supposedly transactional in std lucene, I have encountered some index corruption with hard failures - I think it is because the files are not "synced" when flushed/closed). -----Original Message----- From: Steven Pannell [mailto:[EMAIL PROTECTED] Sent: Thursday, January 05, 2006 2:22 AM To: 'java-dev@lucene.apache.org' Subject: RE: Save to database... Look in the old archive mails and you will find a few people have tried this out. There is even some code around. I have tried this, and to be honest it does not make much sense. The real problem is performance it just takes too long to keep getting the index from the database for performing the query. In the end I realised this was not the way to go and just use the standard filesystem and memory cache for this. Much faster. The only reason for doing this would be if you could not easily reproduce the index and thus wanted to make sure you had some kind of permananet copy. Out of interest why do you want to store in the DB? Steve. -----Original Message----- From: Aditya Liviandi [mailto:[EMAIL PROTECTED] Sent: 05 January 2006 07:15 To: java-dev@lucene.apache.org Subject: Save to database... How would I go about altering lucene so that the index is saved to a database instead? (or has it been done? Wouldn't want to reinvent the wheel there.) -------------------------------------------------- This email is confidential and may be privileged. If you are not the intended recipient, please delete it and notify us immediately. Please do not copy or use it for any purpose, or disclose its contents to any other person. Thank you. -------------------------------------------------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
