The link I provided loads a scant product page, yet it takes over five seconds to load, all because of an insane amount of woocommerce queries. I have latest plugin updates as of 2024-06-09. I use woocommerce, woocommerce subscriptions, woocommerce stripe gateway (stripe, paypal).
I know it’s these three plugins, because I deactive those three and everything on my site loads in less than a second, including my wp-admin pages.
I am running on a beefy vps with 6 cores and 16gb of RAM. My db is 10gb on the same machine and runs on a 100 gb NVME drive. The server isn’t the problem, I have other C# applications running on an identical VPS setup and they run lightning fast.
As a side note, loading my wp-admin dashboard and woocommerce orders list takes over 15 seconds and makes thousands of queries. Deactivating woocommerce plugins, and they load in less than one second. Why does woocommerce run so many queries?
You can force refresh the page by changing the t parameter to something else.
This topic was modified 9 months, 1 week ago by jjxtra.
This topic was modified 9 months, 1 week ago by jjxtra.
The page I need help with: [log in to see the link]
I understand your concern about the slow loading times of your product page and admin dashboard due to the high number of WooCommerce queries.
This is quite unusual, as WooCommerce is designed to function efficiently with the setup you’ve described. However, I’d like to understand your site properly. Please share with us your System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.
Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ Active Plugins (43)
Smart Custom 404 error page [404page]: by Peter Raschendorfer – 11.4.6 LayerSlider: by Kreatura Media – 7.11.1 Ajax Cart AutoUpdate for WooCommerce: by taisho – 1.5.5 Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.2 All In One WP Security: by All In One WP Security & Firewall Team – 5.3.0 Custom Stuff: by – Disable XML-RPC-API: by Neatma – 2.1.5 Free Downloads WooCommerce: by WP Enhanced – 3.5.8.3 Elementor Pro: by Elementor.com – 3.21.3 Elementor: by Elementor.com – 3.21.8 Avada Builder: by ThemeFusion – 3.11.9 Avada Core: by ThemeFusion – 5.11.9 Elementor Header & Footer Builder: by Brainstorm Force Nikhil Chavan – 1.6.35
Head, Footer and Post Injections: by Stefano Lissa – 3.2.8 LoginPress: by LoginPress – 3.0.8 Min and Max Quantity for WooCommerce: by BeRocket – 1.3.4.1 Newsletter: by Stefano Lissa & The Newsletter Team – 8.3.8 PHP Native Password Hash: by Ayesh Karunaratne – 3.0 Rearrange Woocommerce Products: by Aslam Doctor – 4.3.0 reCaptcha for WooCommerce: by I Thirteen Web Solution – 2.37 Redirection: by John Godley – 5.4.2 Simple Custom CSS: by John Regan – 4.0.6 Simple History: by Pär Thernström – 4.15.1 SMNTCS Disable REST API User Endpoints: by Niels Lange – 2.2 The Paste: by Jörn Lund – 2.1.1 Two Factor: by Plugin Contributors – 0.9.1 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.16.47
Coupons & Add to Cart by URL Links for WooCommerce: by WPFactory – 1.7.1 Version Control for jQuery: by Leander Iversen – 3.9 WooCommerce Custom Add To Cart Button: by Kestrel – 1.2.5 Discount Rules Core: by Flycart – 2.6.3 WooCommerce Stripe Gateway: by WooCommerce – 8.3.1 PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.8.3 Woocommerce Side Cart Premium: by XootiX – 3.0 Woo Subscriptions: by WooCommerce – 6.2.0 (update to version 6.3.2 is available) WooCommerce: by Automattic – 8.9.2 Yoast SEO: by Team Yoast – 22.8 WP Crontrol: by John Blackbourn – 1.16.3 WP Fastest Cache Premium: by Emre Vona – 1.7.0 WP Fastest Cache: by Emre Vona – 1.2.7 WP Mail SMTP Pro: by WP Mail SMTP – 4.0.2 wpDiscuz: by gVectors Team – 7.6.19 WPForms Lite: by WPForms – 1.8.8.3 Inactive Plugins (2)
Query Monitor: by John Blackbourn – 3.16.3 WP Mail SMTP: by WP Mail SMTP – 4.0.1 Dropin Plugins ()
advanced-cache.php: advanced-cache.php db.php: Query Monitor Database Class (Drop-in) Must Use Plugins (1)
aios-firewall-loader.php: by – Settings
API Enabled: – Force SSL: – Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) subscription (subscription) variable (variable) variable subscription (variable-subscription)
Name: Avada Version: 7.11.9 Author URL: https://themeforest.net/user/ThemeFusion Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ✔ Templates
To better understand the slow loading issue you are facing, could you record and share a video? This way I’ll be able to compare your results with mine.
You may use a tool like Loom to record videos. Looking forward to your response. 🙂
When you use WooCommerce, your site’s front end or admin panel might slow down a bit because it needs to run many queries. Other factors involved include loading many resources from other plugins, such as payment gateways, subscriptions, page builders, themes, and so on.
I just ran a speed test using Google Page Speed (here is the result), and it seems there’s room for improvement. A few optimizations can significantly increase your site’s speed.
One suggestion is to consider using a light theme that loads quickly and uses minimal resources. Themes like Twenty Twenty-Four, GeneratePress, Blocksy, or Storefront could be great options. They’re all easy to customize, and I’m confident you’ll be able to recreate your current design and layout with minimal effort.
Additionally, you can install the Index WP MySQL For Speed plugin. I’ve found that this plugin enhances both admin and front-end loading speed. And for managing and speeding up your orders page, I recommend switching to HPOS from the legacy posts storage.
I hope this helps! Please let us know how it goes or if you need further assistance.
95% of the time is spent pegging the CPU at 100%. So the front end has little to do with this. I will check out the mysql indexing plugin you suggested.
And the HPOS isn’t compatible with several plugins, so looks like I’m stuck with poor performance due to the inefficient number of queries being made in the woocommerce code.
Deactivated incompatible plugins and enabled HPOS. Load times are improved by ~10%. The root of the issue here is the thousands of queries woocommerce makes just to load a single page. Do you have an ETA on when you’ll be able to fix your code to not make such a horrendous amount of queries?
This reply was modified 9 months, 1 week ago by jjxtra.
Here’s a video showing the horrifying number of queries. Seriously, why is every order id in existance being queried individually? For an orders page, it should be ONE query. Similar insanity happens on the products page and individual product pages, though it’s a little less terrible (only a little).
This reply was modified 9 months, 1 week ago by jjxtra.
Thanks for providing detailed feedback about your experience with WooCommerce. We understand your concerns about the number of queries WooCommerce is making and its impact on your site’s performance.
Our team is continuously working on improving WooCommerce’s performance, and your feedback is invaluable. Could you kindly create a bug or enhancement report on our GitHub repo here? This will allow our developer team to review and offer further insights. Feel free to contribute your own findings to these reports if they seem relevant.
In the meantime, you might consider using a caching plugin, like WP Rocket or FlyingPress, which can help reduce the number of queries by storing the results of some database calls and serving them from memory on subsequent requests.
I also recommend using a managed WordPress hosting service that is optimized for WooCommerce, as these services often have server-side caching and other optimizations in place to handle large numbers of queries.
I wish I could help more, but hopefully, this gets you going in the right direction to get some further insight.
