Post by jsdfwwe3122 » Wed Jun 13, 2018 9:40 pm

We have recently added a lot of products and categories to our opencart store and have found that the website has slowed down substantially. In particular, the page load speed of products and categories as well as the search speed has become very slow.

Our store has 656 categories and 1616 products at the moment.

I am looking for suggestions on how to improve the page load and search speed. We are on a very good VPS server, so it is not the server that is the issues. I am looking for tweaks to the code or configuration that would help.

Thanks for your help!



Tue Feb 21, 2017 2:50 am

Post by thekrotek » Thu Jun 14, 2018 12:12 am

This question was asked gazillion number of times. You need to add indexes to your database. Use search to find a solution.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by

User avatar
Expert Member


Sun Jul 03, 2016 12:24 am

User avatar
Active Member


Fri Mar 16, 2012 10:18 am
Location - Canada, QC

Post by IP_CAM » Fri Jun 15, 2018 10:04 am

Well, at first, you'll have to show us some Results, at best, by testing a
20-30 Product Category Page, in Mobile and Desktop View, by use of
to find out, in detail, what needs to be done, to make sure, to release
all brakes, resulting out of a so-called Default Installation, before talking
about additional steps. Everything else is plain Theory ::)

I'm rarely active at the OC Forum lately. To reach me, contact:
A Demoversion of my free OpenCart LIGHT v. Software Edition
can be seen in real Action here:
1'200+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site:

User avatar
Legendary Member


Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: No registered users and 57 guests