Post by pq36show7 » Fri Oct 19, 2018 9:19 pm

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

Newbie

Posts

Joined
Fri Oct 19, 2018 8:18 pm

Post by thekrotek » Sat Oct 20, 2018 12:20 am

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


User avatar
Active Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by pq36show7 » Mon Oct 22, 2018 3:20 pm

Hi thekrotek,

Thank you very much please can you explain to me how to do this?
Which tables exactly?

What about the query mentioned above?
Just by doing what you describe will that address the speed issue?

Thanks

Newbie

Posts

Joined
Fri Oct 19, 2018 8:18 pm

Post by thekrotek » Mon Oct 22, 2018 4:10 pm

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


User avatar
Active Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by pq36show7 » Mon Oct 22, 2018 4:12 pm

Hi thekrotek,

I have very limited knowledge with MySQL and databases.
Would you be willing to help me?

I appreciate all your help and reponses.
Thank You

Newbie

Posts

Joined
Fri Oct 19, 2018 8:18 pm

Post by thekrotek » Mon Oct 22, 2018 4:54 pm

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


User avatar
Active Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by IP_CAM » Mon Oct 22, 2018 9:23 pm

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

For Sale: Top URL's, including an OpenCart V-Pro Shop!
A wide range of matching Designs can be seen here: http://www.opencart.li
For Information on URL's offered, please contact me at: jti@jacob.ch
Hundreds of Mods in 380+ Repositories for OC v.1.5.x - v.2.3.x
to be found on my Github Site: https://github.com/IP-CAM
Image


User avatar
Legendary Member

Posts

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

Post by pq36show7 » Mon Oct 22, 2018 9:44 pm

Hi,

Just a quick question, how would I go about installing this?
thekrotek is also trying to help me at the moment.

Thanks for all your help Guys!!!

Newbie

Posts

Joined
Fri Oct 19, 2018 8:18 pm

Post by IP_CAM » Mon Oct 22, 2018 10:53 pm

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

For Sale: Top URL's, including an OpenCart V-Pro Shop!
A wide range of matching Designs can be seen here: http://www.opencart.li
For Information on URL's offered, please contact me at: jti@jacob.ch
Hundreds of Mods in 380+ Repositories for OC v.1.5.x - v.2.3.x
to be found on my Github Site: https://github.com/IP-CAM
Image


User avatar
Legendary Member

Posts

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

Post by pq36show7 » Mon Oct 22, 2018 10:59 pm

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

Newbie

Posts

Joined
Fri Oct 19, 2018 8:18 pm

Post by IP_CAM » Mon Oct 22, 2018 11:04 pm

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

For Sale: Top URL's, including an OpenCart V-Pro Shop!
A wide range of matching Designs can be seen here: http://www.opencart.li
For Information on URL's offered, please contact me at: jti@jacob.ch
Hundreds of Mods in 380+ Repositories for OC v.1.5.x - v.2.3.x
to be found on my Github Site: https://github.com/IP-CAM
Image


User avatar
Legendary Member

Posts

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

Post by pq36show7 » Mon Oct 22, 2018 11:31 pm

Ernie,

Email sent.

Thanks

Newbie

Posts

Joined
Fri Oct 19, 2018 8:18 pm

Post by IP_CAM » Mon Oct 22, 2018 11:51 pm

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

Attachments

performance-results.jpg

performance-results.jpg (39.55 KiB) Viewed 103 times


For Sale: Top URL's, including an OpenCart V-Pro Shop!
A wide range of matching Designs can be seen here: http://www.opencart.li
For Information on URL's offered, please contact me at: jti@jacob.ch
Hundreds of Mods in 380+ Repositories for OC v.1.5.x - v.2.3.x
to be found on my Github Site: https://github.com/IP-CAM
Image


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 13 guests