MySQL Forums
Forum List  »  Performance

Re: searching for a substring
Posted by: Boris Burtin
Date: October 31, 2005 01:42PM

Another thing you could look into is using Lucene or something similar to do the text searches. It will require some effort to keep the database and the Lucene index synchronized, but full-text searches will be blisteringly fast and you'll take some load off your database server.

Options: ReplyQuote


Subject
Views
Written By
Posted
2438
October 19, 2005 10:26AM
1420
October 26, 2005 05:13PM
1551
October 28, 2005 04:21AM
Re: searching for a substring
1482
October 31, 2005 01:42PM
1370
November 01, 2005 02:31PM
1339
November 02, 2005 07:07AM
1264
s s
November 25, 2005 12:24AM


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.