How can I optimize X-Cart to increase the performance and the speed of pages generation?
• Be sure to use the static HTML catalog; • Check your X-Cart version. If you have version less 4.2.0 then apply SQL-path: ALTER TABLE xcart_products ADD INDEX manufacturerid(manufacturerid); • It’s possible to perform a site audit and find queries producing the heaviest load in order to optimize them; • It’s also possible to implement a simple caching system for generated pages; • In case of very high server load it’s necessary to optimize server-side configuration and setup a database caching system (memcache, for example).
