The pros of a database full-text index solution is that the administration of the index is much easier than lucene´s index. The coding is much easier too, you don´t need to code you app to support lucene, the only thing you need to do is change your query. In otherside, lucene have many more features than the SQL Server full-text index function. I´m developing a document management system, and I have choosen lucene to do the job. I have much more work to do, because, I have to make a indexing server using SOAP to comunicate with my web application. I needed to do all this job, because, my web application can be clustered in many servers, but the lucene index have to be just in one place. Then, as you can imagine, the problem was the index locks, etc. In this project, the choice to choose lucene, was the number of features that it gives to my application, the great performance, and the fact that my system works in MySQL, Oracle, SQL Server, Informix, PostgreSQL and Firebird database, so, for me, it was impossible to choose the database solution. In my oppinion, if you need a simple solution, to build right away, with a good performance, choose database solution. If you want to do, a more complex system, that will use more features to search the index, and a GREAT performance, use lucene. Lucene is the best solution for larger projects.
I don´t know if you have already worked with oracle, but if you want a database solution, try the oracle one. In my oppinion the full-text function of this database is the best.
Fernando Engelmann Junior Erik Hatcher wrote:
On a past project, we used SQL Server's Index Server capabilities to full-text index and query Word and PDF documents quite successfully.If you're already putting the data into SQL Server, I recommend giving its capabilities a try to see if it suffices, as that would be the easiest way to get full-text search. But if you're not using SQL Server already and want to add it just for indexing, I recommend Lucene for the job.ErikOn Feb 15, 2006, at 12:53 AM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> wrote:Hi,I'm looking to get some idea of which full-text engine is faster and scalesbetter: SQL Server or Lucene. My index will contain millions of shortdocuments of approximately 100 words. Please advise of the pros and cons.Thank You, Greg
smime.p7s
Description: S/MIME Cryptographic Signature
