[SOLVED] Some Elements Take Long to Load

Recently (3 days ago), and without any changes I'm aware of, some elements on our site have started taking a while to load, namely

Cart (remains grey and says "Loading")
Brand
Product Code
Availability
Price

I've used Chrome's Performance recorder to view what's happening but can't make head or tail out of it other than the live chat Tawk.to plugin takes a while to load, but that has always been the case and the price normally loads before the live chat icon.

Is anyone brainier than me able to have a look and tell me what they see?

The site is https://progenix.co.za

Thanks in advance

You have some extension that hides elements with catalog/view/javascript/hideprcprd/def/common.css and unhides them later. Try to work out which extension in is the disable it to see if anything improves.

Your store getting slower and slower because of the extra database queries that are being run to get the total product counts - turn these off.

Home >Stores> Settings> Options> Products "Category Product Count" Off

it does show a warning to having these turned on.

"Show the number of products inside the subcategories in the storefront header category menu. Be warned, this will cause an extreme performance hit for stores with a lot of subcategories!"

also see
https://www.antropy.co.uk/blog/speed-up ... ed-issues/

How To Speed Up OpenCart (and/or Fix Speed Issues)

ADD Creative wrote: ↑

Fri Sep 22, 2023 8:10 pm

You have some extension that hides elements with catalog/view/javascript/hideprcprd/def/common.css and unhides them later. Try to work out which extension in is the disable it to see if anything improves.

The thing is nothing was changed on the site side between it loading in milliseconds and suddenly having this large delay. No new extensions or plugins have been installed for several weeks.

The contents of the file you mentioned:

.price, .col-sm-4 ul.list-unstyled{opacity:0;}

That's it, nothing else in it at all.

WaxedPerfection wrote: ↑

Fri Sep 22, 2023 9:51 pm

Your store getting slower and slower because of the extra database queries that are being run to get the total product counts - turn these off.

Home >Stores> Settings> Options> Products "Category Product Count" Off

it does show a warning to having these turned on.

"Show the number of products inside the subcategories in the storefront header category menu. Be warned, this will cause an extreme performance hit for stores with a lot of subcategories!"

also see
https://www.antropy.co.uk/blog/speed-up ... ed-issues/

How To Speed Up OpenCart (and/or Fix Speed Issues)

I gave this a try, but turning that on or off doesn't make a difference. Additionally, no new categories have been added for several months, yet the issue only started, seemingly out of the blue, a few days ago.

I've also been through the link you sent,

• Turn Off Category Counts - no difference
• Install a Good Caching Extension - there isn't a caching extension other than LightSpeed, and with how frequently the pricing and products change this could pose a problem. LightSpeed can already be a problem when pricing is changed from the product listing without editing a product (I use Admin Quick Edit Pro, which, from Catelog -> Products allows you to edit the price by simply clicking on it) as that doesn't purge the cache until clicking "Purge LightSpeed Cache at the top right, while editing a product directly does. If I don't purge the cache, the edited product shows the incorrect price until added to cart. Seeing as the delay is in showing availability and price, I think that even caching everything other than price/qty would have the same issue
• Add Database Indices - this seems unrelated, "but every 5-10 minutes it would slow right down and pages would take 20+ seconds to load" - the slow loading isn't random, and certainly isn't that slow. Searching is also quite speedy.
• Trim Error Log Files Automatically - the log file is relatively empty...
• Fix the Code to Remove Notices and Warnings - ...mainly because of this
• Use a CSS-only Theme - my theme is the default theme with some edits, all CSS
• Use CloudFlare - I had to disable this because of massive caching issues, even worse than those I described for LightSpeed (I can't purge the CloudFlare cache without requesting my hosting company to do so, and it is bad enough that massive changes such as the homepage layout being changed could take hours to reflect)
• Reduce the filesize of your images - images are already small by modern standards, and the image loading isn't the problem
• Make Sure You're Not Suffering from the vQmod "checked.cache" Issue - the file is 20KB
• Make Sure Your /tmp Folders Aren't Filling Up - less than 2MB there
• Consider switching database tables' engines to InnoDB - this seemed promising, but on reading the paragraph... This isn't a massive store (fairly large by South African standards, but certainly no Amazon or NewEgg, LOL) and even if the database requests were piling up for an hour at a time there aren't enough for it to be much slower than instantaneous.

Oh, I just found another website speed test which seems to give a better breakdown than those I'd been using. According to Uptrends' test running on a product page rather than the homepage, the big delays before the price/qty/etc show are all cart requests:



You can ignore the (biggest) delay in the beginning, because a lot of it is TTFB as the site is hosted in South Africa. We don't serve any international customers, so local hosting makes the most sense. TTFB is in measured in seconds for international testing, but sub 100ms local.

Progenix wrote: ↑

Sat Sep 23, 2023 4:28 pm

The thing is nothing was changed on the site side between it loading in milliseconds and suddenly having this large delay. No new extensions or plugins have been installed for several weeks.

The contents of the file you mentioned:

.price, .col-sm-4 ul.list-unstyled{opacity:0;}

That's it, nothing else in it at all.

Yes that line hides the Brand, Product Code, Availability and Price. It's not shown again until some code in catalog/view/javascript/hideprcprd/def/common.js runs at a later stage, probably once all other scripts have loaded. You need to work out what extension "hideprcprd" is.

Caching won't help with JavaScript issues and will often make things worse as they will add more delay in loading things like the cart.

Progenix wrote: ↑

Fri Sep 22, 2023 7:41 pm

Recently (3 days ago), and without any changes I'm aware of, some elements on our site have started taking a while to load, namely

Do you have products in a cart when you test it?

See indexer script from my extensions.

ADD Creative wrote: ↑

Mon Sep 25, 2023 5:51 am

Progenix wrote: ↑

Sat Sep 23, 2023 4:28 pm

The thing is nothing was changed on the site side between it loading in milliseconds and suddenly having this large delay. No new extensions or plugins have been installed for several weeks.

The contents of the file you mentioned:

.price, .col-sm-4 ul.list-unstyled{opacity:0;}

That's it, nothing else in it at all.

Yes that line hides the Brand, Product Code, Availability and Price. It's not shown again until some code in catalog/view/javascript/hideprcprd/def/common.js runs at a later stage, probably once all other scripts have loaded. You need to work out what extension "hideprcprd" is.

The support and knowledge around here is amazing. I recognize it as |OCT| Hide Price For Individual Product but didn't know what the file is doing. I disabled the add-on (it's not really needed anymore, it's only used when new products are coming out and the price is still under embargo which is SELDOM. I think I can live with it being a bit slow for the 1-2 days when the plug-in is needed and just leave it disabled the rest of the time

It's strange that the plug-in has been enabled for quite a long time without misbehaving. Maybe it's "not" misbehaving but something else is which is taking a while longer to load that usual (South Africa has had some international internet speed issues lately due to a cable break). I suspect it's related to Google Analytics as the related files have long candles in the performance reports, but who knows.

THANK YOU!

Progenix wrote: ↑

Mon Sep 25, 2023 4:52 pm

The support and knowledge around here is amazing. I recognize it as |OCT| Hide Price For Individual Product but didn't know what the file is doing. I disabled the add-on (it's not really needed anymore, it's only used when new products are coming out and the price is still under embargo which is SELDOM. I think I can live with it being a bit slow for the 1-2 days when the plug-in is needed and just leave it disabled the rest of the time

Great news, so please add [SOLVED] to the start of the post title.

paulfeakins wrote: ↑

Mon Sep 25, 2023 7:25 pm

Progenix wrote: ↑

Mon Sep 25, 2023 4:52 pm

The support and knowledge around here is amazing. I recognize it as |OCT| Hide Price For Individual Product but didn't know what the file is doing. I disabled the add-on (it's not really needed anymore, it's only used when new products are coming out and the price is still under embargo which is SELDOM. I think I can live with it being a bit slow for the 1-2 days when the plug-in is needed and just leave it disabled the rest of the time

Great news, so please add [SOLVED] to the start of the post title.

I have done so

Progenix wrote: ↑

Tue Sep 26, 2023 6:41 pm

paulfeakins wrote: ↑

Mon Sep 25, 2023 7:25 pm

Great news, so please add [SOLVED] to the start of the post title.

I have done so

Thanks