MySQL Forums
Forum List  »  Full-Text Search

Full text performance vs keyword tables.
Posted by: Joseph Hagerty
Date: September 11, 2008 11:46PM

So I have a customer that stores a database of about 2million records. One of the fields in this database is a company name. In order to search this field, they split the field up into individual words, and create a new record in a different table for each word, indexed to the company id. This results in about 8 million records.

For example: Table one has a record with a company id & name of "1","Mysql AB Inc". In the second table, there are 3 records:

"1", Mysql"
"2", "AB"
"3", "Inc"

As this process require a weekly rebuild, and the current process is a mess, I was curious about using Full Text Searching and whether or not that would represent any performance hit or benefit.


Options: ReplyQuote

Written By
Full text performance vs keyword tables.
September 11, 2008 11:46PM

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.