I upgraded Foundthru to the latest WooCommerce and after onboarding (updating the database) it keeps checking if I need to update the database with expensive calls on wp-admin.
On foundthru with 1 million products, this increases wp-admin page load time from 3 seconds to 28 seconds.
There’s no easy fix I can apply for this inside Scalability Pro so I had to edit a couple of WooCommerce files to fix this. That should be safe since the next WooCommerce update will overwrite the fixes which will mean onboarding can run again for the next update.
More info about the source files here on this facebook post:
https://www.facebook.com/groups/advanced.woocommerce/posts/5550114498336257/
Specifically, the files you need to edit are:
- /woocommerce/packages/woocommerce-admin/src/Features/OnboardingTasks/Tasks/Products.php
- /woocommerce/packages/woocommerce-admin/src/Features/OnboardingTasks/Tasks/Appearance.php
You’re looking for lines at the start of 5 different functions that look like this:
$task = new Task( self::get_task() );
Just put the command return; before that line so it becomes:
return; $task = new Task( self::get_task() );
These edits will be overwritten on the next WooCommerce update when they’ve hopefully fixed this, and because the updates are overwritten it means any required onboarding for the next version will kick in again.
Hi Dave,
I am a WordPress and Woocommerce dev. Recently I have been working on a website where we have a large number of products.
We have used woocommerce widgets on the blog page sidebar. It takes 8-10 seconds for woo-commerce slow queries to get widget HTML results. Please check this page https://www.kideno.com/en/what-memories-should-you-aim-to-create-for-your-child/
This happens whenever we are accessing not cached page.
Will your plugin help us to reduce query time?
Regards
Mahboob
You need my Super Speedy Filters plugin. I tried originally to bake everything into Scalability Pro but in the end Search and Filters had to be separate plugins. You’ll also need redis-cache.
Spoke too soon again – 6.31 still has this issue. 27 seconds added to wp-admin. Maybe it will go away when the new Product Attribute Table has been created.
https://i.imgur.com/oCs3IQq.png
I’ll report back once that’s happened.
Did the issue go away after the Product Attribute Lookup Table was created?
It still hasn’t completed on my million product site – I increased the batch size to 10,000 – it should be done soon. I don’t like how they build these tables – they make them super reliable on every site but as a result, they take ages to build.
My tables use MySQL 8 features (recursive CTEs) to make building and maintaining these tables really fast.
My bad – I’d updated our demo sites where we test everything to WooCommerce 6.31 which is actually the latest version and this issue is already fixed.
Foundthru was still on an older version which I’ve now updated and confirmed this issue is also fixed there.