Live Chat Software by Kayako |
Knowledgebase: General Q&A
|
Should I use MySQL full-text search option ?
Posted by Esvon Support on 22 June 2012 10:27 AM
|
|
|
As your website grows, switching to MySQL full-text search can be beneficial for database performance improvement. It will certainly have a noticeable effect if you have dozens of thousands of listings. You may want to read documentation covering MySQL full-text search because it can be tweaked on server level if you have VPS or you are allowed to modify MySQL configuration. For example, by default only words of 4 characters or more are indexed and can be found by full-text search. If you decrease this default minimum value, you may also want to create a custom stopword list because there are about 600 words that are excluded from FULLTEXT indexes. Some of those two letter words omitted are: on, of, it, is. | |
|
|
|
Comments (0)