MySQL Forums
Forum List  »  Full-Text Search

FULLTEXT Indexing
Posted by: Doug Funk
Date: April 20, 2005 10:37PM

As a heavy user of SQL Server full-text indexing, and Index Server, I would like to see if MySQL could fill a big gap we have had to work around in those technologies. We add about 40,000 new documents to our database every day. In order to quickly index new documents and have them available for searching, we use Index Server, since SQL Server full-text can not get its indexes updated in less than 'hours'. Then after the documents are a few months old, and static, we index them with SQL Server full-text indexes. Our application knows which type of index to search based on the age of the requested documents.

If, when a record is added to a MySQL database, a 'procedure' could be called to force that record to be indexed, the indexes could be kept up-to-date as records are added, and there would be no need to rebuild complete indexes. It seems like this could be like an 'on request' incremental population of the indexes.

Solving this problem would make MySQL a 'no-brainer' replacement for our current system.

Options: ReplyQuote


Subject
Views
Written By
Posted
FULLTEXT Indexing
4110
April 20, 2005 10:37PM
2690
April 21, 2005 06:40AM
2489
May 02, 2005 04:51AM
2951
May 12, 2005 11:11AM
2676
July 28, 2005 07:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.