Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 In-Reply-To: <[EMAIL PROTECTED]> X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-RCPT-TO: <[EMAIL PROTECTED]> Status: U X-UIDL: 332997001
The initial motivation behind switching from intermedia to Lucene was a first step in achieving DB abstraction because if you rely on intermedia for your indexing and searching purposes you're pretty much stuck with Oracle, an excellent DB but if you're business is growing the licensing fees become massive. Another thing is that I don't maintain one index on the Database server, I maintain an index on each webserver witch allowed me to reduce the average load on the DB machine by 78%, it's a little bit of a synchronization might mare but we've had it in place for the past three months without incident plus you have redundant indexes in-case one becomes corrupted. Furthermore the traffic between the DB machine and the webserver witch was inflated by having to pass search results back and forth has been dwarfed. Now the true joy behind using Lucene is the performance boost you'll get, we had intermedia customized and tuned to our needs yet Lucene was able to give a 200% increase in performance , a huge asset to our site witch is mainly search driven. PS: the reason why we create XML files and then hand them to Lucene is because, the files are then used for display purposes and caching purposes, because once they are transmitted to the webserver machines they save me the hassle of retrieving them from the database since they are the most recent version of the documents. Nader Henein -----Original Message----- From: Mariusz Dziewierz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 4:23 PM To: Lucene Users List Subject: Re: Lucene and RDBMS. Nader S. Henein wrote: > We had to do the same thing, we moved from an Oracle Intermedia search to > Lucene (much better) the data is stored in the database. Could you give some reasons which lead you to conclusion that Lucene is much better than Oracle Intermedia in terms of searching data stored in database? I'm currently reviewing technologies related to text mining and I am very curious about your motives because I haven't opportunity to evaluate both technologies yet. -- Mariusz Dziewierz -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
