Site speed extremely slow

Hello

Version 3.0.2.0 - Default theme, lightly modified.
https://gpzzone.com

This site is live and functioning, but is still yet to be fully populated - yesterday for some inexplicable reason it ground to a halt with page transitions taking anything up to 20 seconds.

Overnight there were a couple of errors recorded in the error log....

2019-03-13 23:47:40 - PHP Warning: mysqli::__construct(): (HY000/2002): Connection timed out in /var/www/vhosts/gpzzone.com/httpsdocs/system/library/db/mysqli.php on line 7

2019-03-13 23:47:40 - PHP Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in /var/www/vhosts/gpzzone.com/httpsdocs/system/library/db/mysqli.php on line 10

There has been no recent work on the site other than the addition of a dozen or so new products, interestingly the admin side of things is funtioning at a normal speed, but the forn end is painful.

I've double checked both of the configs and I can't see anything awry - the database details are both as they should be.

I understand from previous posts that the errors indicate a DB connection issue but neither I, nor my hosts can identify what is tripping it up.

Does anyone have any suggestions?

Attached is a screenshot from GTMetrix which illustrates the issue.

Thanks in advance.

Update:-

I've just turned off SEO url's and the site is a lot quicker - but still 4-7 seconds between page transitions.
Category product count is OFF and GZip is set at 9.

Wisdom appreciated!

works just fine from here.
first page load may be a little slow with DOM ready at about 2.3 sec and fully loaded at about 4 sec but the second page load is very fast.

I agree, but that's since I turned the SEO url's off - If I turn them back on again it's dog slow.
I'm just researching the SEO url vs speed situation now.

I have tweaked the rewrite rules in htaccess and re-enabled the "use SEO urls" and whether by design or co-incidence the site is back up and running to a good standard.

Thank you.

Well, you still have some way to go, as it looks !
But GTMETRIX.COM tells you loud and clear, what still needs to be done
to get up near 90/88 at least !
Good Luck!
Ernie
---

yes but they should stop advising people to use Etags or Last-Modified headers or I will no longer take them seriously.

letxobnav wrote: ↑

Fri Mar 15, 2019 1:44 pm

they should stop advising people to use Etags or Last-Modified headers or I will no longer take them seriously.

Well, I am more an Opportunist, and so far, GTMetrix is still the most 'informative'
Testplace, when it comes to not only produce results, but informing testers, where
what is still waiting, to be improved. Without that kind of free assistance, I would
not have been able, to get my Test Sites up to 98-99(DT) / 91 - 92(M) (best cached IMGs)
And such a Cat-Page results in a 99(M) / 100(DT) by use of the 'latest' Google Tester,
to me, this even confirms, that the GTMetrix Testsite is doing a good Job.
---
GTMetrix only lacks the (former) Google Testsite Function, to download the
full Package of near-perfect-zipped images at once. I always tested my
Cat/Brands/Specials Pages with 'show all on Page' Settings, to get all the
re-zipped images in one each package per Download, and that saved me
lots of time.
---
But the Site, linked above, still has a couple of misses, like that crazy Logo size:
3'660px × 1'044px (scaled to 360px × 103px) , and UnPro-things like:
catalog/Fuel%20system/xxxx.jpg
catalog/Chain%20and%20sprockets/xxxx.jpg
multi word links/paths with white space GAP in between words,
which just should not exist in a clean and proper Server Code Installation.

And most everything else is still 'set' as by OC default. But even by use of
a simple optimized .htaccess file, the Performance Results could
be lifted up by about 20% for both Values shown. This one here could
do this job quite well, I tested it just now again on one of my Test Sites,
just to make sure, that it works: PageSpeed Score (98%) YSlow Score (91%)
htaccess - File Zip Download:
http://www.ipc.li/os/htaccess.zip
It should basically function in later OC Versions too, but I really
cannot tell, when it comes to OC-3 Versions, sorry about that.
---
And with 'subdomain-like' linking JS / CSS Code + Images, another +5-8%
would result out of such. And finally, after combining the header
'default-linked/loaded' OC 'style' Code into the bootstrap.min.css
file, and JS Code into the jquery-2.1.1.min.js File, and compress
those files again:
https://csscompressor.com/
http://javascriptcompressor.com/
---
It then only requires something like this:
Output Compression Extension, to at least get a
94/90 (DT) and 90/90 (M) GTMetrix 20 Product Category Page Result.
https://www.opencart.com/index.php?rout ... ess+output
Or then end up, like shown here:
https://gtmetrix.com/reports/www.hitline.info/6mNgqRrF
But it would still not go to 100% Performance, even if the images
would be compressed best ! But the YSLOW Result would so reach 92%
---
More info on this here:
viewtopic.php?f=190&t=205407&p=749031
viewtopic.php?f=202&t=210083
---
Enable Subdomain linked Font-Awesome PIC's:
( ALREADY INCLUDED in the above .htaccess File! )
viewtopic.php?f=182&t=210119
---
For real OC-Fan's, it's not hard to achieve, it just takes
some free time and lot's of testing, to belong to the Pageload Pro's!
Good Luck!
Ernie
PS. I would not have invested so much time, but I'm an old ex-Biker, and was
licensed Bike Mechanic by Profession, on Vespa, BMW, Triumph, Honda, Yamaha ....

you need to move to a better hosting provider or vps for your site.
your total products are not too many.
you can try my site, over 2.3 million products, pages loads lightening fast.

Besides the hardware (network/cpu) side of things, page load times have very little to do with the number of products you have and very much with the extend of the provided features on your website.

over 2.3 million products, pages loads lightening fast

Well, it's not as impressive, as you might think, since your Listings
only consist out of a simple Number, and such takes very little time to
load, and it uses only 13 requests. It's similar, comparing an empty + fully
loaded 40 ton Truck. And the Test Results are still 20% below of what they
could/should be, to be qualified as real Performer.

But as 'letxobnav' already mentioned above, adding Code, like FB/TW/e.t.c.
to such Pages likely has much more 'dramatic' effects, as well as products
with a large Number of Options.

From the Viewpoint of most 'regular' Visitors, Search/Category/Special/
Bestseller/Latest/e.t.c. Listing Pages need to show up as quick as possible,
to keep Visitors happy, to efficiently finding, what they're looking for.

Ernie
---
Image Link:
download/file.php?mode=view&id=36660

Exactly, basically site performance is an AND issue and not an OR issue.

If your site is not optimized for performance, it will be slow on any good host and an optimized site will be slow on any bad host.
Host performances are not always under your direct control and network latency certainly is not.

I run my site from my home on an I7 8GB machine over a normal ADSL line so I know a little bit about those bottlenecks.

So I find the best strategy is to tackle the performance bottlenecks within your control, which yield the highest gains and the lowest pains, first.

The original poster has a rather default site which is, arguably, not very well optimized so he has much room for improvements there and IP_CAM's suggestions are a must start for those. I sure am following those, I have to and if that means dumping functionality because it is too slow and I cannot fix it, I will, reluctantly.

You on the other hand have a very optimized site, as in you have basically stripped every functionality except for the search function and you no longer have a responsive site, which might be very appropriate for your specialized semiconductor target audience and if you do not need existing functionality, by all means, remove them.

As such, you don't even need a good host as I am sure you could run your site on a mobile phone and it would still perform satisfactory.

ps. you do need to check your search page if there is no search keyword entered as that looks bad, please get rid of horizontally scrolling tables as those are punishable by death and your cart gives me a 500 error.

chongshengdz wrote: ↑

Sat Mar 16, 2019 11:03 pm

you need to move to a better hosting provider or vps for your site.
your total products are not too many.
you can try my site, over 2.3 million products, pages loads lightening fast.

chongshengdz, your site is very fast for 2.3 million products, would care to share what kind of hosting or extension you use to manage such speeds? I've got less than 50K items and my site loads much slower than yours.

thanks in advance.

Joe

over 2.3 million products, pages loads lightening fast.

Well, that Site cannot be compared with those, using specific images
per Product, and Product Options, just to mention two time-consuming
details. It would rather belong to the 'low speed' Sites, and most likely
produce miserable results, considering, what the popular Test Sites mean
to that absolutely 'regular default' OC Installation.

It's not a matter of the amount of products, it depends on, what one is
adding to them on Data, Pic's, Options, and more ...
Just to avoid Misunderstandings !
Ernie
---
Image Link:
download/file.php?mode=view&id=37177