Clever Geek Handbook

Build a search engine with SQL 2000 and ASP.NET C #

I am looking to create a search engine that will be based on 5 columns in a SQL 2000 DB. I have looked through Lucene.NET and read the documentation for it, but wondering if anyone has any previous experience?

thank

+1


source to share


4 answers


IMHO it's not so much about performance as about maintainability. In order to index your content with Lucene.NET, you need to create some kind of mechanism (launcher service) that will add new rows (and remove deleted rows) from the Lucene index.



From a beginner's point of view, I think it might be easier to use the built-in full-text search engine of SQL Server.

+2


source


I haven't worked with Lucene yet, but my friend and he said that their performance is 4-5 times better with lucene than full text indexing.



+1


source


Better performance? I think it depends a lot on the volume and how you expect the data to scale.

SQL Server Full Text is far superior in my opinion. To get this to work with lucene, you need a process to maintain the index by fetching data from the SQL database.

+1


source


You can use Lucene Index or SQL FTS Index. I personally lean towards Lucena from a simple point of view. It is also not a black box. Many of which will work (and both can work) are divided into query load, data size, and data refresh rate. Lucene does provide a well-worn path to building highly scalable website search solutions. In the future, please add more information about your issue.

+1


source






More articles:


All Articles