Page 1 of 1

Opencart speed Version 2.3.0.2 with many of categories/products

Posted: Wed Jun 13, 2018 9:40 pm
by jsdfwwe3122
We have recently added a lot of products and categories to our opencart 2.3.0.2 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!

Re: Opencart speed Version 2.3.0.2 with many of categories/products

Posted: Thu Jun 14, 2018 12:12 am
by thekrotek
This question was asked gazillion number of times. You need to add indexes to your database. Use search to find a solution.

Re: Opencart speed Version 2.3.0.2 with many of categories/products

Posted: Fri Jun 15, 2018 5:25 am
by agatha65
... and cache your category menus

Re: Opencart speed Version 2.3.0.2 with many of categories/products

Posted: Fri Jun 15, 2018 10:04 am
by IP_CAM
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
http://gtmetrix.com
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 ::)
Ernie