WooCommerce Admin Query Fixes

Some slow admin queries don’t come from a general setting you can tune, they come from one specific piece of code doing something expensive. These are hard to track down yourself because the query looks unremarkable until you see it running against a large table. Scalability Pro includes three targeted fixes for exactly this kind of problem, each in the Bloat tab and each an individual toggle you can switch on only if it applies to you.

"Fix WooCommerce onboarding code" deals with the onboarding logic WooCommerce uses to decide whether to show its setup wizard. To make that decision it runs a slow COUNT grouped by post status. That check makes sense on a brand-new install, but it keeps running afterwards on established stores where the answer never changes. This fix returns a fast fixed result instead of running the count.

"Fix Order Delivery Date plugin Admin Query" targets a third-party plugin. The Order Delivery Date plugin runs a slow query that does a GROUP BY over a timestamp stored in meta values, which forces the database to work through a lot of rows. This fix caches the result so the heavy query doesn’t run on every load.

"Remove custom-meta select box" addresses a metabox that builds a dropdown of meta keys by scanning the whole of wp_postmeta for distinct keys. On a large store that table is enormous and the scan is painfully slow. This fix replaces that scan with a tiny query, so the box stops trawling your entire meta table.

In short: three specific admin queries, WooCommerce onboarding, the Order Delivery Date plugin, and a custom-meta dropdown, each scan far more data than they need to. The Bloat tab gives you an individual toggle for each fix, so you can switch off just the ones that are slowing your store.