Post by gpzzone » Thu Mar 14, 2019 5:20 pm

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.

Attachments

waiting.jpg

waiting.jpg (95.63 KiB) Viewed 602 times


Newbie

Posts

Joined
Sat Aug 25, 2018 4:08 am

Post by gpzzone » Thu Mar 14, 2019 5:46 pm

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!

Newbie

Posts

Joined
Sat Aug 25, 2018 4:08 am

Post by letxobnav » Thu Mar 14, 2019 6:23 pm

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.

Crystal Light Centrum Taiwan


Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm

Post by gpzzone » Thu Mar 14, 2019 6:41 pm

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.

Newbie

Posts

Joined
Sat Aug 25, 2018 4:08 am

Post by gpzzone » Thu Mar 14, 2019 8:08 pm

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.

Newbie

Posts

Joined
Sat Aug 25, 2018 4:08 am

Post by IP_CAM » Fri Mar 15, 2019 12:37 pm

Well, you still have some way to go, as it looks ! :choke: ::)
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
---
Image

Attachments

gpzzone_gtmetrix_com_results.jpg

gpzzone_gtmetrix_com_results.jpg (39.46 KiB) Viewed 532 times


For Sale: Turnkey URLs with Opencart installed
My latest Opencart LIGHT Testsite: http://www.hitline.info
Attacker IP Blocks are denied from further access to my Sites!
Just contact me for more Information at: jti@jacob.ch
760 FREE OC Extension-Repositories - from OC v.1.5.x up
on the largest Opencart-Mod 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 letxobnav » Fri Mar 15, 2019 1:44 pm

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

Crystal Light Centrum Taiwan


Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm

Post by IP_CAM » Sat Mar 16, 2019 11:42 am

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% :D
---
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 ....

For Sale: Turnkey URLs with Opencart installed
My latest Opencart LIGHT Testsite: http://www.hitline.info
Attacker IP Blocks are denied from further access to my Sites!
Just contact me for more Information at: jti@jacob.ch
760 FREE OC Extension-Repositories - from OC v.1.5.x up
on the largest Opencart-Mod 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 chongshengdz » 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.

https://www.transistorfet.com/
https://www.transistormosfet.com/


New member

Posts

Joined
Sat Apr 12, 2014 10:18 pm


Post by letxobnav » Sun Mar 17, 2019 9:05 am

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.

Crystal Light Centrum Taiwan


Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm

Post by IP_CAM » Sun Mar 17, 2019 2:04 pm

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

Attachments

transistormosfet_test_results.jpg

transistormosfet_test_results.jpg (210.12 KiB) Viewed 371 times


For Sale: Turnkey URLs with Opencart installed
My latest Opencart LIGHT Testsite: http://www.hitline.info
Attacker IP Blocks are denied from further access to my Sites!
Just contact me for more Information at: jti@jacob.ch
760 FREE OC Extension-Repositories - from OC v.1.5.x up
on the largest Opencart-Mod 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 letxobnav » Sun Mar 17, 2019 4:05 pm

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.

Crystal Light Centrum Taiwan


Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Who is online

Users browsing this forum: No registered users and 3 guests