Live Chat Software by Kayako |
Knowledgebase: General Q&A
Many categories - tip to improve MySQL performance
Posted by Esvon Support on 22 June 2012 11:02 AM
|
|
If you have many categories (hundreds, thousands) and your classifieds software version is 4.0.11 or less, run the following SQL statements from Admin Area -> SQL Command (replace "ec4_" with your tables prefix): ALTER TABLE ec4_category DROP INDEX name; ALTER TABLE ec4_category ADD KEY name ( weight, name(5) ) | |
|
Comments (0)