Live Chat Software by Kayako |
Knowledgebase: General Q&A
|
Will MySQL upgrade from 3.23 to 4.0 version help to speed up full text search/indexing routines at my website ?
Posted by - NA - on 13 September 2005 01:29 PM
|
|
|
We always recommend to use the latest stable MySQL version. There are enough things that run faster on MySQL 4.x and later versions (query cache if enabled, SQL_CALC_FOUND_ROWS option, full-text indexing, more efficient SQL syntax in some cases, etc), our software automatically uses some of these and other tweaks if they are available. E.g. MySQL full-text index creation time was greatly reduced starting from MySQL 4.0, so if you run full-text search on MySQL 3.23.x and have more than several thousands of listings, it won't hurt to upgrade from MySQL 3.23.x to MySQL 4+ to take advantage of improved full text search algorithms performance. | |
|
|
|
Comments (0)