Articles
Advanced Archive Query Tweaks
Beyond the big archive optimisations, the Query Speed tab has four smaller toggles. Each targets a…
Ajax Attribute Editing
When you open a product for editing in WooCommerce, the Attributes panel loads every term for…
Alter the main query to use EXISTS rather than LEFT JOIN
Available since 6.32. Off by default. WordPress filters products by taxonomy, such as a category, an…
Avoid Expensive WP All Export meta_key Enumeration
When you edit an export in WP All Export, it tries to show you every custom…
Block Slow Outbound HTTP Calls in wp-admin
Available since 6.29.30. Plugins and themes make outbound HTTP requests while wp-admin pages render: licence checks,…
Cache Author and User Counts
Some of the slowest queries in wp-admin come from counts you never asked for. On the…
Cache Post Counts
WordPress and WooCommerce constantly want to know how many posts exist in each status: how many…
Cache WooCommerce Shortcodes
Product grid shortcodes are convenient, but they’re expensive. The [sale_products], [best_selling_products] and Flatsome [ux_products] shortcodes each…
Checkout Purge Shield
Stop cache-purge plugins slowing your WooCommerce checkout by reacting to order notes.
Compatibility and Integrations
Scalability Pro sits underneath everything else on your site and speeds up the raw SQL that…
Custom Database Indexes
WordPress ships with surprisingly few indexes on its most heavily queried tables. Tables like wp_postmeta, wp_term_relationships…
Custom Query Alterations
The optimisations in the Query Speed tab are deliberately conservative. They’re written to apply where they’re…
Defer Term Counting
Every time you add or update a product or post, WordPress and WooCommerce recount how many…
Diagnosing WP All Import Performance Issues with Scalability Pro
Scalability Pro does a lot of work to optimise your WP All Import jobs, but sometimes…
Export and Import Your Settings
If you run several sites, configuring Scalability Pro from scratch on each one is a chore.…
Faster Archive Pages
Archive pages are any page that lists other items: your blog, the shop page, product category…
Faster Imports
Imports slow down on large sites for reasons that have little to do with the importer…
Faster wp-admin
A slow wp-admin on a large site usually comes from a handful of queries that scan…
Faster XML Sitemap Generation
XML sitemap plugins list every published post or product, usually sorted by last-modified date and fetched…
Finding Slow Queries
Before you can fix what’s slow, you need to know which queries are slow and where…
Measuring the Performance Win
It is worth measuring what Scalability Pro actually does for your site, rather than trusting the…
Optimise Action Scheduler
Action Scheduler is the background job system used by WooCommerce, WooCommerce Subscriptions and a lot of…
Optimise Product Attributes Lookup
WooCommerce keeps a product attribute lookup table to make filtering and faceted searches fast. That table…
Optimise WooCommerce Updates
WooCommerce runs DELETE operations against wp_options on a number of admin and front-end pages, mostly to…
Remove Image Sizes Globally
Every time an image is uploaded or imported, WordPress generates a resized copy for every registered…
Remove SQL_CALC_FOUND_ROWS
When WordPress runs the main query for an archive page, it doesn’t just fetch the 10…
Remove WooCommerce Dashboard Bloat
WooCommerce adds a number of elements to wp-admin that most shop owners never look at, and…
Speed Up Slow Themes
Some themes and plugins look up images and other attachments by their guid, the unique address…
Speeding Up Single Product and Post Pages
Most of Scalability Pro’s work is aimed at archive pages, the lists of products and posts,…
Super Speedy Archives Add-on
On a large site, archive pages get expensive. Author archives, taxonomy and category archives, and filtered…
Unload Plugins safely by page
Stop plugins loading on the anonymous front-end pages where Performance Analysis measured that they do nothing.
WooCommerce Admin Query Fixes
Some slow admin queries don’t come from a general setting you can tune, they come from…
WooCommerce Optimisations
The indexes and query options in Scalability Pro help every WordPress site, WooCommerce included. On top…
Still stuck? Join the Discord.
Get direct advice from Dave Hilditch and hundreds of other performance experts using our plugins every day.
