If your requiremens for search aren't to complex AND your database isn't too large, then you should considers SQL Server's Full Text service. Works well, and with SQL Server 2005 it is quite usable.
We have a database of 20M records with full text documents, and that is more then SQL can cope with for all sorts of reasons. We used Lucene to build an indexer that keeps in sync with a SQL table, and allows for VERY fast searches. All it gives back are unique ID's wich we can use to lookup the records again in the SQL database. René -----Original Message----- From: vietpd [mailto:[EMAIL PROTECTED] Sent: dinsdag 20 februari 2007 15:18 To: [email protected] Subject: How to store index data efficiently. Hello everybody, There is one problem that make me wonder so much, and I post this to collect your advices. I use dotlucene to index raw data, and use SQL server to store indexed data(text data that was parsed from many other sources). Howerver, I'm not experienced with dotlucene and I don't know if it's better or not storing indexed data in SQL instead of storing it with dotlucene. Can anyone give me advices please? Thanks and regards
