Do I Need Scalability Pro?

Scalability Pro isn’t for every site. It solves a specific problem, and if your site doesn’t have that problem, it won’t make a noticeable difference. This article is here to help you work out honestly whether you need it before you buy, rather than after.

What problem it solves

Most WordPress performance advice is about caching, and caching is genuinely useful. But a page cache only helps once a page has already been generated and stored. It does nothing for the first, uncached visitor, nothing for wp-admin, and nothing for imports, because those pages can’t be served from cache. Underneath all of that sits the real bottleneck on a large site: slow SQL running against a database that WordPress never indexed properly for scale.

WordPress ships with surprisingly few indexes on its most heavily queried tables. Tables like wp_postmeta, wp_term_relationships and wp_options were designed for small sites. Once those tables grow into the hundreds of thousands or millions of rows, ordinary queries fall back to full table scans, reading every single row to answer even a simple question. That is where the slowdowns start, and it is why big archives, WooCommerce shops and busy admin screens grind to a halt.

Scalability Pro fixes this at the source. It adds the missing database indexes, rewrites slow queries so they can use those indexes, caches expensive counts, and removes unnecessary or badly-performing WordPress and WooCommerce functionality. The goal is a site fast enough that any page-caching plugin can actually populate its cache, and fast enough on the paths that can never be cached. It is what lets people run a million or more products on a modest server rather than an expensive one.

Signs you need it

You probably need Scalability Pro if you recognise several of these:

• Your Posts or Products list screens in wp-admin are slow to load, or bulk actions crawl.
• Product category, shop, blog or custom post type archive pages are slow, especially the first uncached load.
• Imports run slowly or time out, or product and stock updates take far longer than they should.
• Your time to first byte (TTFB) is high on uncached pages.
• The site falls over under load, or gets steadily slower as the catalogue grows.
• Query Monitor shows genuinely slow SQL queries on your slow pages, with a low overall query count.
• You see a wp_options performance warning, or thousands of autoloaded options bloating the table.
• Your wp_postmeta table has more than roughly 5,000 to 10,000 rows, which happens even on sites with a modest number of posts.

The quickest way to check is the free Query Monitor plugin. Look at your slowest pages. If you see slow queries reported with a low query count, that is exactly what Scalability Pro fixes. As a rough guide, more than 100 queries on a page is worth investigating, though a high count is a symptom rather than always a problem.

Who it’s for

Scalability Pro is aimed at sites that have outgrown WordPress’s default database performance:

• WooCommerce stores at scale. Large catalogues, expensive admin queries, slow shop and category pages, and slow order screens.
• Large custom post type sites. It speeds up WP_Query for any post type, so blog archives, directories, listings and forums benefit too. It is not WooCommerce-only.
• Import-heavy sites. Sites running WP All Import, WP All Export or other bulk feeds, where the import is slow or the daily price and stock update drags.
• Affiliate and feed sites. Datafeedr and similar setups that hold very large numbers of products and update them regularly.

If your site is large, growing, and spends its time waiting on the database rather than the network, it is the kind of site Scalability Pro was built for.

You probably don’t need it if…

Be honest here, because there is no point paying for a fix to a problem you don’t have. You likely do not need Scalability Pro if:

• Your site is small, with few products or posts, and already loads quickly.
• Query Monitor shows a low query count and no slow queries on your pages.
• Your slowness is caused by something Scalability Pro doesn’t address. If Query Monitor shows thousands of queries rather than slow ones, that points to a filter or search plugin, and you likely need Super Speedy Filters or Super Speedy Search instead. If it shows high PHP time and low SQL time, the bottleneck is PHP-side code, not the database.

Scalability Pro won’t speed up a tiny site, and it won’t rewrite a poorly-coded filter or search plugin from the outside. What it does is stop a growing site from slowing down as it scales. There is a 60-day money-back guarantee, so if you are unsure, you can measure the before and after on your own site.

How it fits alongside a caching plugin

Scalability Pro is not a caching plugin and it is not a replacement for one. The two do different jobs and work well together. A page cache hides the problem for visitors who hit a cached page. Scalability Pro fixes the underlying queries so that the paths a cache can never touch, admin, imports and the first uncached visitor, are fast too, and so the cache can populate quickly in the first place. Run it alongside your existing page cache and, ideally, a Redis object cache as well.

What to do next

If the signs above describe your site, the fastest route to a faster site is the Quick Start Guide. Install, enter your licence, and create all the indexes first. That step is completely safe and is often enough on its own.

To diagnose exactly which queries are slow and which plugin is causing them, see Finding Slow Queries. If your problem looks like a bloated options table or a wp_options warning, see Managing the wp_options Table and Autoload.

Further reading

Related products

Scalability ProSpeed up your whole site – big catalogues, big databases, no re-architecture