Index WP MySQL For Speed vs Scalability Pro

Dave Hilditch •
Shop sorted by price on 1,000,000 WooCommerce products: Index WP MySQL For Speed 4,210 ms, Scalability Pro 290 ms

Want faster results? Try Scalability Pro on your store.

Get Scalability Pro →

Index WP MySQL For Speed vs Scalability Pro, in one line: Index WP MySQL For Speed is a free, well-made plugin that replaces WordPress’s database keys with better ones. Scalability Pro adds its own indexes, rewrites the slow queries WordPress and WooCommerce send, and serves product listings from its built-in Archives table. On a 1,000,000-product WooCommerce store, sorting the shop took 4.2 seconds with Index WP MySQL For Speed and 0.29 seconds with Scalability Pro.

Last updated: 13 November 2026. Tested with Index WP MySQL For Speed 1.6.0 and Scalability Pro 6.45.1.

Overview of Index WP MySQL For Speed

Index WP MySQL For Speed is written by Oliver Jones (OllieJones on wordpress.org), with rjasdfiii as a contributor, and its readme credits “Rick James for everything”. It has been on wordpress.org since June 2021, has more than 50,000 active installations, and holds 4.8 out of 5 from 99 reviews. It is free, GPL licensed, and the code is on GitHub. There is no paid edition; it takes donations through GitHub Sponsors.

What it does is narrow and done well. It replaces the default keys on wp_posts, wp_postmeta, wp_options, wp_users, wp_usermeta, the comment and term meta tables, and WooCommerce’s order meta tables with keys designed for how WordPress actually queries them. It can revert to the standard keys at any time, it has a wp index-mysql WP-CLI command for large tables where the dashboard would time out, and it includes a query monitor that samples page views and lists the slowest queries.

Visit Index WP MySQL For Speed →

What the two have in common

Both start from the same idea: WordPress’s default database indexes were designed for a blog, and they fall over on a large store. Both add better indexes and both can remove them again. On the wp-admin product editor, where the default keys are at their worst, the two plugins produce almost identical results.

Where they differ

Indexes only, or indexes and queries. Index WP MySQL For Speed changes keys and nothing else. That has a hard limit: if a query is badly shaped, a better key cannot fix it. Scalability Pro also rewrites queries as they are sent. It removes redundant GROUP BY and DISTINCT clauses, replaces the count WordPress runs to render “page 1 of 5,000”, and adds indexes for specific WooCommerce lookups such as the attribute filter table and the queries every RSS feed runs.

Sorting a large catalogue. A sorted shop page is slow in WordPress because the sort value lives in a different table from the product, so MariaDB has to read and sort a huge number of rows to find the first 16. No index on the existing tables changes that, which is why Index WP MySQL For Speed left the price, popularity and rating sorts at 4.1 to 4.3 seconds. Scalability Pro’s Archives table keeps one row per product with the columns the shop sorts and filters on, indexed in the order the shop asks for them, so the database reads the first page straight off the index. Those sorts took 253 to 290 ms, 14.5 to 16.8 times faster than Index WP MySQL For Speed.

The plain shop page too. The unsorted shop, the shop sorted by newest, page 50 of the shop and the product category page were all 2.6 to 3.3 times faster than with Index WP MySQL For Speed. The shop for a logged-in customer went from 1.9 seconds to 271 ms.

Generic keys can choose the wrong plan. We added a numeric custom-field filter to the shop, the kind of query filter plugins send for stock or sale price. With Index WP MySQL For Speed, the stock filter went from 1.7 seconds to 37.0 seconds, and the sale price filter from 0.7 seconds to 36.9 seconds. The SQL was identical; its postmeta keys changed the plan MariaDB chose. Scalability Pro served the stock filter in 441 ms, because Enable good settings found the slow filter in the Performance Analysis history and added the stock field to the Archives table.

The sale price filter is the one page where Scalability Pro did not win. The sale prices hold decimals, but the filter compares them as whole numbers, which WordPress does by truncating each price. A typed copy of that field would include and exclude different products from WordPress, so Scalability Pro declines to serve it and leaves WordPress’s own query in place. That page took 754 ms, against 712 ms with WordPress’s default keys. A filter that compares prices as decimals can be served.

More than the database. Scalability Pro also handles options autoloading, unloading plugins a request does not need, and cron and heartbeat control. Index WP MySQL For Speed deliberately stays out of those areas.

Benchmark: 1,000,000 WooCommerce products

Every configuration was measured on the same evening from one restore of the same server snapshot: 1,000,000 products in 425 categories, WordPress 7.1.2, WooCommerce 11.1.2, MariaDB 10.11.17 and PHP 8.2.34, on a 4 vCPU Hetzner server with 7.6 GB of RAM. Index WP MySQL For Speed 1.6.0 had keys enabled on every table it supports. Scalability Pro 6.45.1 was configured only by Enable good settings (wp spro recommended), with no hand tuning. Super Speedy Performance Analysis measured each page, and the figures are median server page-generation times from three samples after a warm-up. Each of the 30 pages we checked for correctness returned the same products in the same order as WordPress default, apart from products tied on the sort value itself.

PageWordPress defaultIndex WP MySQL For Speed 1.6.0Scalability Pro 6.45.1Scalability Pro vs Index WP
Shop sorted by price4,227 ms4,210 ms290 ms14.5× faster
Shop sorted by price, high to low4,405 ms4,205 ms282 ms14.9× faster
Shop sorted by popularity4,098 ms4,131 ms257 ms16.1× faster
Shop sorted by rating4,311 ms4,253 ms253 ms16.8× faster
Shop sorted by newest645 ms721 ms244 ms3.0× faster
Shop, first page937 ms968 ms297 ms3.3× faster
Shop, page 50973 ms961 ms324 ms3.0× faster
Shop, logged-in customer1,959 ms1,932 ms271 ms7.1× faster
Product category754 ms737 ms282 ms2.6× faster
Category sorted by price578 ms572 ms292 ms2.0× faster
Category sorted by popularity591 ms561 ms318 ms1.8× faster
Shop filtered by colour2,186 ms2,142 ms825 ms2.6× faster
Shop filtered by colour and size1,846 ms1,915 ms885 ms2.2× faster
Category filtered by colour574 ms606 ms465 ms1.3× faster
Stock filter (custom field, 1 to 5)1,707 ms37,018 ms441 ms83.9× faster
Sale price filter (custom field, 10 to 20)712 ms36,908 ms754 ms48.9× faster
Price range filter (10 to 20)566 ms573 ms494 mslevel
RSS feed2,633 ms659 ms85 ms7.8× faster
Edit product (wp-admin)1,682 ms236 ms241 mslevel
New product (wp-admin)1,601 ms271 ms250 mslevel
Median server page-generation time, 1,000,000 products, 13 November 2026. Lower is better. Shaded: more than 15% faster than WordPress default.
Performance Tip

The headline: on a 1,000,000-product store, Scalability Pro served the shop sorted by price in 290 ms, where Index WP MySQL For Speed took 4,210 ms. That is 14.5 times faster, with nothing configured by hand.

Neither plugin changed front-end search (about 1.5 to 1.7 seconds) or the wp-admin product search (about 5.2 seconds); Super Speedy Search is the fix for search, so it is not part of this comparison. The wp-admin products list and the post editor stayed within 10% in every configuration. Pages under 300 ms, such as the home page, cart, checkout and single products, varied more between runs than between plugins.

Every page we measured (54 pages)
PageWordPress defaultIndex WP MySQL For Speed 1.6.0Scalability Pro 6.45.1
Product search (wp-admin)5,199 ms5,269 ms5,215 ms
Shop sorted by price, high to low4,405 ms4,205 ms282 ms
Shop sorted by rating4,311 ms4,253 ms253 ms
Shop sorted by price4,227 ms4,210 ms290 ms
Shop sorted by popularity4,098 ms4,131 ms257 ms
RSS feed2,633 ms659 ms85 ms
Shop filtered by colour2,186 ms2,142 ms825 ms
Shop, logged-in customer1,959 ms1,932 ms271 ms
Shop filtered by colour and size1,846 ms1,915 ms885 ms
Stock filter (custom field, 1 to 5)1,707 ms37,018 ms441 ms
Edit product (wp-admin)1,682 ms236 ms241 ms
Search, no results1,635 ms1,703 ms1,703 ms
New product (wp-admin)1,601 ms271 ms250 ms
Search, many results1,544 ms1,527 ms1,649 ms
Shop, page 50973 ms961 ms324 ms
Shop, first page937 ms968 ms297 ms
Products list (wp-admin)800 ms824 ms811 ms
New post (wp-admin)767 ms796 ms800 ms
Product category754 ms737 ms282 ms
Edit post (wp-admin)753 ms827 ms745 ms
Products list by category (wp-admin)721 ms715 ms706 ms
Sale price filter (custom field, 10 to 20)712 ms36,908 ms754 ms
Shop sorted by newest645 ms721 ms244 ms
Category sorted by popularity591 ms561 ms318 ms
Category sorted by price578 ms572 ms292 ms
Category filtered by colour574 ms606 ms465 ms
Price range filter (10 to 20)566 ms573 ms494 ms
Category sorted by price, high to low554 ms585 ms299 ms
Category sorted by rating551 ms552 ms330 ms
Category sorted by newest408 ms454 ms294 ms
Category + price range filter373 ms385 ms362 ms
Out of stock filter298 ms324 ms318 ms
Single product, logged-in customer216 ms213 ms323 ms
Product categories (wp-admin)214 ms209 ms217 ms
Order search (wp-admin)213 ms183 ms197 ms
Posts list (wp-admin)212 ms237 ms281 ms
Plugins (wp-admin)209 ms217 ms220 ms
Single product207 ms211 ms222 ms
Media library (wp-admin)204 ms164 ms202 ms
Dashboard (wp-admin)203 ms173 ms235 ms
Colour terms (wp-admin)201 ms165 ms190 ms
Attributes (wp-admin)200 ms205 ms198 ms
Checkout196 ms159 ms189 ms
Cart191 ms164 ms202 ms
Single post190 ms163 ms193 ms
404 page181 ms136 ms144 ms
My orders, customer180 ms144 ms176 ms
Orders (wp-admin)172 ms158 ms213 ms
My account, logged out157 ms128 ms172 ms
Home page155 ms157 ms190 ms
Blog category145 ms168 ms185 ms
REST API posts140 ms140 ms120 ms
My account, customer138 ms133 ms171 ms
Every page measured, slowest first. Shaded: more than 15% faster than WordPress default.

Feature comparison

Index WP MySQL For SpeedScalability Pro
PriceFreefrom €79.00 per year
Active installations50,000+Sold directly, not listed on wordpress.org
Better indexes on WordPress tablesYesYes
Indexes on WooCommerce lookup tablesOrder meta tablesAttribute lookup, SKU lookup and others
Pre-sorted product listing table for shop sorts and filtersNoYes, built in (Archives)
Rewrites slow queriesNoYes
Faster pagination countsNoYes
Slow query monitorYes, built inNo; measurement is done by Super Speedy Performance Analysis
Revert to standard keysYesYes
WP-CLIYesYes
Options autoload, plugin unloading, cron and heartbeatNoYes
Supportwordpress.org forum, answered by the authorDirect Discord access to the developer

What its users say

Its reviews are overwhelmingly positive. On 15 June 2026 fff654 titled their review “divided by 2 my CPU load” and added “GUI is excellent on what it does, and how to revert.” The same review gives a useful warning for shared hosting: adding keys to the post and meta tables timed out from the dashboard and had to be done from the command line.

Negative reviews are few and old. The most detailed, from November 2022, “Crashed my website when trying to RESTORE”, reports that the site “was slower” after adding keys and ends “Install with caution!”. The author replied the same day offering to investigate.

When Index WP MySQL For Speed is the better choice

If your site is mostly posts, pages and users rather than a big product catalogue, start with Index WP MySQL For Speed. It costs nothing, the wp-admin editor gains were as large as Scalability Pro’s in our test, and its query monitor is a good way to find out what is actually slow. If you do not sell anything and your budget is zero, it is the right first step.

When Scalability Pro is the better choice

When the slow pages are your shop: sorting, attribute filters, category pages and feeds on tens or hundreds of thousands of products. Those pages are slow because of the queries and the table layout, not just the keys, and that is where Scalability Pro made the difference in our test. It is also the safer choice if your store uses a custom-field filter for stock, sale price or similar.

Switching

Revert Index WP MySQL For Speed’s keys first, using its own wp index-mysql disable command, then deactivate it. Running both is not recommended, because two sets of indexes on the same columns give MariaDB more ways to pick a bad plan. Then install Scalability Pro and run Enable good settings. On our 1,000,000-product test store that took about an hour, most of it building the Archives table. The table is built alongside the live one and swapped in when it is complete, so the shop keeps working while it builds.

The bottom line

Index WP MySQL For Speed is a good free plugin, and its fixes to wp-admin are real. On a big WooCommerce store, though, the slow pages are the shop pages, and better keys did not speed those up in our test. On custom-field filters they made pages more than 20 times slower. Scalability Pro made the sorted shop pages about 15 times faster, the plain shop and category pages about 3 times faster, and the stock filter 84 times faster than Index WP MySQL For Speed.

Frequently asked questions

Is Index WP MySQL For Speed safe to use?

Yes. It only changes indexes, never your data, and it can restore WordPress’s standard keys at any time. Test custom-field filters on your own shop after enabling it, because that is where we saw a large slowdown.

Can I use Index WP MySQL For Speed and Scalability Pro together?

You can, but we do not recommend it. Both add indexes to the same tables, and overlapping indexes make it harder for the database to choose a good plan. Pick one.

Does Scalability Pro speed up search?

No. Neither plugin changed search times in our test. Fast product and admin search is what Super Speedy Search is for.

What do others say about Scalability Pro?

★★★★★
inkoop — September 2025

This plugin made the websites for my clients quite faster, something other "speed" plugins couldn't do. If you need one "speed" plugin, it's this one! You only need to keep in mind that to achieve this, you switch off some calculations and some options you might need. So you have to read carefully the description of what the option does.

★★★★★
Dirk — August 2016

I ordered the WPI Performance Plugin and I´m absolutly impressed. I never thought that I can get that speed on my site. I´m planing to build more sites and shure I will buy the WPI Performance Plugin for that sites too.

★★★★★
Erik Dalgaard — January 2017

I have a site with many products and heard about Scalability Pro and after installing this plugin my site got blazing fast. I recommend this anytime for everybody who want fast woocommerce site. Thanks to Dave for support.

Want faster results? Try Scalability Pro on your store.

Get Scalability Pro →

Comments