Hi Guys,
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
You need to add indexes to some database tables to increase the loading speed. Use PHPMyAdmin for that.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
You need to know, how to work with database and have some MySQL language understanding. Otherwise I wouldn't recommend you to do it yourself.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Yeah, sure, drop me an email and we'll discuss this further.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Something like this could also be used, to fully index a DB, and eventually
change the default OC DB Engine to a faster one in OC Versions.
Ernie
https://github.com/IP-CAM/opencart-turbo
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.
Well, there is nothing to install, just upload the PHP File into the Shop ROOT
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
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.
Hi Ernie,
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
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
Well, calling a Doctor only makes no sense, if he's not able, to take a look. 
So, better show a link to this Site, then, you might get some usable reply.
Ernie
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.
Well, this is more or less a 'default' like -installation, when it comes to the way it works.
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
---
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.
Who is online
Users browsing this forum: No registered users and 135 guests
