MySQL Forums
Forum List  »  Performance

Yes, you can expect a performance boost.
Posted by: Wade Bowmer
Date: March 16, 2005 05:09PM

I recently did that for one of the databases I look after and the difference was phenomenal: over 99% of the searches the users are more than 100 times faster. This table also has a lot of inserts and there is no slowdown that I can detect. I don't know about bulk-inserts except that importing a full dump on the development box is no slower that I've noticed.

There is a very big "but": it is *not* as simple as re-indexing and altering the SQL. There is a mind-set to searching that has to change, too. Using LIKE is very simplistic and brute-force. Using MATCH is very like using an Internet search engine, even more so in Boolean mode. Remember to train your users.

Wade.

Options: ReplyQuote


Subject
Views
Written By
Posted
8535
March 15, 2005 04:17AM
Yes, you can expect a performance boost.
3600
March 16, 2005 05:09PM


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.