Slow loading product pages

Your uploaded monitors don’t show any outrageously slow queries, sorry to say. You could try capturing another monitor, and perform some of the slow page view operations while the monitor is being capture. Don’t forget to upload the monitor. Also please upload your database metadata from the plugin’s About page.

A couple of things to try.

1. Your MariaDB buffer pool is onlye 128MiB, and is running nearly full. You might try making it bigger.
2. Try adding a persistent object cache. I have one here. SQLite Object Cache – WordPress plugin | www.ads-software.com

Let me know if you upload more information, and the results of my suggestions.

Thanks for the response!

I increased the buffer pool a great deal, setup SQLite Object cache and uploaded the results again. Still experiencing a very slow load time: https://i.imgur.com/lu0J8SL.png

OK, I ran your staging site through the Lighthouse tool in chrome devtools.

As I’m sure you know it’s TTFB (time-to-first-byte) that gives you problems. But here’s the weird thing: I don’t see any outrageously slow queries in your recently uploaded monitor. I do see some that fetch many product variants, but they don’t take too much time.

If this were my project my next troubleshooting stop would be the Query Monitor plugin. Why does the initial page view take so long to generate? That’s the question.

(I might also try disabling WP Rocket and your CDN as a first troubleshooting step, to rule out misconfigurations there.)

Thank you for the plugin recommendations, they’ve been very helpful.

I swapped my theme for Storefront theme and noticed no speed change on the G10 page. WP Rocket also didn’t cause any speed change. However, I did find plugins causing the speed issues on the G10 page:

• WooCommerce Product Table (barn2) = +11s
• PayPal for WooCommerce = +7s
• Discount Rules and Dynamic Pricing for WooCommerce = +16s

I can do away with Discount Rules and Dynamic Pricing for WooCommerce but the other two I need to keep. After checking server usage percentages, I notice we’re always below 10% usage on CPU.

Are there any server configs I can increase values on to increase the speed of queries?

I’ve conversed with the product table plugin’s support and already have it optimized the best way according to them. Their lazy load feature doesn’t display variant details or allow filters to function the way we need; I have a caching setting in this plugin enabled.

I re-uploaded results with Discount Rules and Dynamic Pricing for WooCommerce disabled.