Features

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…

Avoid Expensive WP All Export meta_key Enumeration

When you edit an export in WP All Export, it tries to show you every custom…

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 , and Flatsome [ux_products] shortcodes each run…

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…

Object caching per-row for wp-admin lists

We have added an option to use object-caching per-row for lists in your wp-admin area. Probably…

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…

Optimised XML sitemap generation speed

In version 4.44 of Scalability Pro, we added XML sitemap generation optimisations. These optimisations optimise both…

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…

Rewrite LEFT JOINs to WHERE EXISTS

When you filter an archive by taxonomy or by a meta value, WordPress builds the query…

Scalability Pro speeds up wp-admin and your site in general

The indexes speed up multiple queries around your site including wp-admin. Additional options are available to…

Scalability Pro speeds up your archive pages by speeding up WP_Query

Archive pages are the pages on your WordPress site that contain lists of other pages. Your…

Scalability Pro speeds up your imports

Plugins like Datafeedr and WP All Import store information in wp_postmeta about imports and the SQL…

Specific WooCommerce Optimisations

The options above all help WooCommerce, but if you have a large site or a large…

Speed up Slow Themes

There are many slow themes that request images from the database using the GUID against wp_posts.…

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 Listings Add-on

On a large site, archive pages get expensive. Author archives, taxonomy and category archives, and filtered…

Switch Off Phone Home

Plugins and themes frequently make outbound HTTP requests while you’re working in wp-admin. They check for…

Using the Slow Query Log

Before you can fix what’s slow, you need to know which queries are slow and where…

WooCommerce Admin Query Fixes

Some slow admin queries don’t come from a general setting you can tune, they come from…