- New SQL enhancement for Scalability Pro to fix WooCommerce long-running query in the product-hero block - August 31, 2023
- Create a static favicon.ico to avoid surplus PHP requests for rush traffic - July 25, 2023
- Breaking Through WooCommerce Restrictions with Super Speedy Filters: The Power of Pretty Permalinks - May 10, 2023
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:
Specifically, the files you need to edit are:
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.