Reputation: 4007
My opencart products page is taking too much time to load, I tried to optimize query and database but it didn't work for me. I tested my page from pingdom page test. It takes more than 15 sec. I query fetch more than 300 records this might be a reason, and it increases server cup usage, how do I solve this issue.
Upvotes: 0
Views: 2965
Reputation: 4007
Here I found the solution
Disable product counts in Admin as
System -> Settings -> Edit -> Option -> Category Product Count
. Then install this mod: http://www.opencart.com/index.php?route ... n_id=10999
Upvotes: 1
Reputation:
As your page is loading all the 300 records, its very obvious that it'll take more time. So you can implement the ajax loading of products instead, you'll gain major performance benefit.
Further , as per the pingdom report , your site has 0 grade for the : Leverage browser caching Please improve it. More details : http://gtmetrix.com/leverage-browser-caching.html
As per the Request Analysis and Size Analysis of your site, image influence is too much. You have to consider the improvements for the images as well.
There is one Free Module in opencart to speed up the site, if it's compatible with your opencart version then you can try it.
http://www.opencart.com/index.php?route=extension/extension/info&extension_id=13580
Upvotes: 1