We have a Opencart web site running on version 2.1.0.2.
We have uploaded some products to it and it now running very slow.
The web site currently has in the region of 134,000 products.
I have done a test on tools.pingdom.com
Performance Grade: C (73)
Page Size: 1.5MB
Load time: 13.57s
Requests: 46
I have spoken to our Hosting Company and they say it is to do with a Query that keeps running itself.
They reckon 0ver 40 times a minute.
Could this be the reason the web site is now taking so long to load.
Please see query below:
# Time: 181018 9:42:56
# User@Host: okfr_db[okfr_db] @ localhost [] Id: 467
# Query_time: 1.244718 Lock_time: 0.000082 Rows_sent: 134164 Rows_examined: 536656
SET timestamp=1539855776;
SELECT pd.tag FROM fr_product_description pd
INNER JOIN fr_product p ON pd.product_id = p.product_id
WHERE
pd.language_id = '1'
ORDER BY p.viewed DESC;
Can someone please help and tell me how to solve this. My knowledge on SQL is very limited.
Thanks
AS
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
change the default OC DB Engine to a faster one in OC Versions.
Ernie
https://github.com/IP-CAM/opencart-turbo
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.
section, and execute it by calling it's file name. Then, you will see, which bottons
to press, to get the DB indexed, and eventually switched to InnoDB, if it's not
already working this way by default.
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.
I have already done this and notice a difference already.
Some pages still load a bit slow, will these improve over time?
Or is there something else that can be done?
I have seen one of your online stores, which too be honest is as fast as a rocket.
I am still getting over 5 secs load time om the Home Page on tools.pingdom.com
Thanks for all your help thus far.
Tony
So, better show a link to this Site, then, you might get some usable reply.
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.
But on GTMETRIX, you will find out, what still needs to be done, to unleash the real
power of OC. One should be able, to get it up to at least 85/85, or even better, but it takes
a little time, to make it all work. Possibly, TheKrotek will be willing to do it for you for a
couple of small Bills, otherwise, you could look around in some of my Performance-related
Postings here, to find out on how to do it, since I am not doing Custom Support.
Ernie
https://gtmetrix.com
---
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.
Users browsing this forum: No registered users and 288 guests