Zen Cart is a very powerful software–some programmers and designers won’t use anything else. After a lot of research and testing I came to the conclusion that Zen Cart could indeed be an excellent Ecommerce solution for some businesses, but a total headache for others. Since it’s been around for so long there is a lot of user feedback available.
Optimize Your Zen Cart Site
Use Recommended Web Hosting
Optimize the database
mysqlcheck -u<username> -p<password> --auto-repair --check --optimize <database name>
If you have phpMyAdmin installed on your web hosting, your Zen Cart database, select all tables and pick the ‘Optimize table’ option from the drop-down menu located below the tables’ list.
The DirectAdmin or WHM/cPAnel control panels make the database management even easier through a simple, intuitive web-based graphical interface.