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

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!

Newbie

Posts

Joined
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 support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


User avatar
Active Member

Posts

Joined
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
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

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

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

Users browsing this forum: No registered users and 71 guests