Scalability Pro
Speed up your whole site - big catalogues, big databases, no re-architecture
Your site was fast when it was small. Now archive pages, imports and wp-admin screens are waiting on the database. Scalability Pro adds the indexes WordPress leaves out, stops it counting rows nobody reads, and defers the work that turns an import into an overnight job.
Your site grew. The database work grew faster.
Nothing broke. The same queries simply got more rows to read, and the ones WordPress never indexed got slowest first.
Your product list used to load. Now you click Products and wait, and you know roughly how long, so you go and do something else while it thinks.
The import you used to run at lunchtime you now start at night, and check in the morning to see whether it finished. Someone asks why the shop feels slow and you say you are working on it.
Every one of those is the same problem, and it is not your hosting. It is the database doing work that grew faster than your catalogue did.
“I was managing a WooCommerce store with 350k products, and the load times were painfully long. But after adding Scalability Pro, the speed boost was incredible! What used to take forever now loads in a fraction of the time.”
wp_postmeta.meta_key, so the distinct-key lookup that core’s custom fields box runs on every admin page reads the whole table. Measured on a 2.03 million row postmeta table, that query examined 2,040,368 rows in 950ms. With the index it examines 205 rows in 1.4ms.None of which helps if you cannot tell whether it worked. Most speed plugins ask you to take that on faith. This one measures.
Set it up in one click, then measure what it bought you
The guided setup creates every index that applies to your site and turns on every optimisation a visitor cannot see. With the free Performance Analysis plugin installed it profiles your key pages before and after, so the result is a number rather than a feeling.
A customer walkthrough
A customer walks through a large WooCommerce setup running Scalability Pro alongside Super Speedy Search.
Recorded by a customer on their own site rather than as a controlled benchmark. The two plugins fix different queries.
“Overall the result is incredible – loading speeds went from almost 10 seconds to 1-1.5 seconds (my site has 500k posts and others).”
“The plugin improved category loading and page display from over 15 seconds to 2 seconds instantly. Over 250,000 products on WooCommerce.”
“I purchased Scalability Pro as an experiment to see how it affected WP ALL IMPORT. It managed to turn a 3 day stock sync process into a 1 hour process.”
What Monday looks like afterwards
You open Products and the list is there.
The import you used to start on a Friday night finishes over lunch, and you watch it finish rather than checking in the morning. Nobody on the team has quietly learned to work around wp-admin, because there is nothing left to work around. When someone asks why the shop is quick now, you can show them the number.
Then the catalogue doubles and none of it changes. That is the difference between fixing the database work and fixing the symptoms.
Pick the licence that matches your sites, run the one-click setup, and let it show you the before and after.
Invest in Speed
Yearly plans include a year of updates and support and the plugin keeps working afterwards – renew at 30% off. Upgrade to a lifetime plan within 60 days and just pay the difference. Backed by our 60-day money-back guarantee.
1 Site
- Yearly licence – 1 year of updates and support, keeps working afterwards
- 1 Site License
- All optimisations & indexes
- 1 support seat – chat live with our engineers on Discord
5 Sites
- Yearly licence – 1 year of updates and support, keeps working afterwards
- 5 Site Licenses
- All optimisations & indexes
- 1 support seat – chat live with our engineers on Discord
25 Sites
- Yearly licence – 1 year of updates and support, keeps working afterwards
- 25 Site Licenses
- All optimisations & indexes
- 1 support seat – chat live with our engineers on Discord
- Priority support
5 Sites
- Lifetime licence – updates and support for life
- 5 Site Licenses
- All optimisations & indexes
- 1 support seat – chat live with our engineers on Discord
25 Sites
- Lifetime licence – updates and support for life
- 25 Site Licenses
- All optimisations & indexes
- 1 support seat – chat live with our engineers on Discord
- Priority support
250 Sites
- Lifetime licence – updates and support for life
- 250 Site Licenses
- All optimisations & indexes
- 2 support seats – chat live with our engineers on Discord
- Priority support
Start with the plan you need today.
If you need more sites later, move up without buying the plugin twice.
to try it properly
Ask for a full refund within 60 days of purchase, for any reason.
Upgrade and pay the difference
Within 60 days, your original payment counts in full towards a larger plan, including lifetime.
Example based on our €79 yearly and €279 lifetime plans.
Upgrading later? You still get credit after 60 days, though the credit reduces over time on yearly plans.
How do yearly renewals work?
A yearly licence includes one year of updates and support. The plugin keeps working after that. Renewal for further updates and support is optional. Renew before or within one month after expiry for 30% off, within six months for 20% off, or later for 10% off. Full terms
Agency or hosting company? Get in touch for custom pricing
Evidence from large WordPress sites
Scalability Pro is built and tested against large WordPress and WooCommerce databases. Each figure below names what was measured and where.
See it running on two public demo stores. FoundThru runs more than 900,000 products on a $20/month server with no page caching. The new Super Speedy demo store runs 100,000 products with over 250,000 variations.
A day on a big store
You open a category page. To print “page 1 of 5,000” WordPress counts every matching row first, which on a large catalogue is usually the most expensive thing the page does. Scalability Pro fetches one extra row instead. That proves a next page exists without counting the other 200,000, and you pick whether visitors see an exact total, an estimate or just Next.
You open Products to fix one price. Before the list even draws, WordPress asks for every distinct custom field name on the site, and the counts above the list are a query each. On the store this was measured against, that one question read 2,040,368 rows and took 950ms. With the index it reads 205 rows in 1.4ms, and you get roughly a second back on every admin page you open for the rest of the day.
You start the Friday import. Before your import tool writes anything, it looks up every single row to decide whether that is a new product or an update to an existing one. Fifty thousand rows is fifty thousand lookups, and unindexed each one is a scan. Scalability Pro indexes the columns those lookups actually use: the WooCommerce SKU table, post titles, guids, custom fields, and seven indexes on WP All Import’s own bookkeeping tables. Then it defers term counting, which WordPress otherwise redoes after every insert, and recounts afterwards in batches of 500.
The indexing is also why your shop stays up. An import that stops scanning tables stops saturating the database, so the front end is no longer queueing behind it. The import finishing sooner is the half you expected. The site staying usable while it runs is the half people write in to tell us about.
“Today put this tool on my website with 50,000+ products. The page loading times were really 10 to 20 seconds during imports via wpallimport. Set all steps and go through and now around 1 to 2.”
A customer places an order. Every note WooCommerce writes to that order, payment complete, stock reduced, each status change, looks like a page edit to a cache-purge plugin, and it purges. On a test store that was 30 outbound HTTP requests inside one checkout. On superspeedyplugins.com they ran to the timeout and added roughly 19 seconds. The shield takes it to none.
And the rest of it
- WordPress and WooCommerce list screens. Cached author and status counts, suppressed months and categories dropdowns, and a per-page limit you set yourself.
- Options autoload. Measured page scans show which options your site really reads, so the blob loaded on every request stops carrying what nothing uses.
- Outbound calls from other plugins. Rules you write can stop a third-party licence, update or telemetry call while an admin page renders. They can never apply to the front end, REST, cron, commerce screens or 22 named payment gateway hosts.
- Order admin on a busy store. The user count behind the orders list dropdown is cached instead of recounted, and the object cache stops being flushed on every write while an import runs.
- Plugins loading on pages that never use them. Per-page rules stop a plugin loading where a Performance Analysis deep scan proved it does nothing. Anonymous page views only, never a POST, wp-admin, REST or checkout.
- One optimisation at a time. Each can be switched on at a named WordPress hook and off again at another, so it applies to a single archive loop rather than the whole request.
wp spro on the command line, or let an AI agent read the plan over MCP and apply it once you confirm.Check the fit before you buy
Scalability Pro is a good fit when
- The site became slow as its products, posts, orders, users, terms or metadata grew.
- Archive pages, imports, exports or wp-admin screens are waiting on database queries.
- You can test changes on staging and want control over individual optimisations.
- You need database changes and measurement, not another front-end asset minifier.
What Scalability Pro does not replace
- A suitable database server and correctly sized hosting. It reduces wasted work, but it cannot repair an overloaded or failing server.
- A dedicated product-filter engine. Use Super Speedy Filters for catalogue filtering at scale.
- A dedicated search engine. Use Super Speedy Search for site and product search.
- Front-end image, CSS or JavaScript optimisation. Scalability Pro works on the database and on how WordPress runs.

Scalability Pro Knowledge Base
View full Knowledge Base →What's new in Scalability Pro?
View full changelog →- Alter main query to use EXISTS rather than LEFT JOIN leaves pages Super Speedy Filters serves from its own index to Super Speedy Filters, so they no longer carry an extra product visibility check.
- Fixed database errors about missing
scalability_pro_post_count_cacheandscalability_pro_transient_cachetables after activating Scalability Pro with WP-CLI: activation creates the cache tables before anything uses them.
- Updated super-speedy-settings to 1.14.3 update downloads now send the licence key in a request header instead of the download URL.
- Fixed native WordPress search running slower with Scalability Pro's indexes installed on large stores: the
wpi_scalability_pro_sitemapsindex now leads withpost_typeand is rebuilt automatically after updating.
- Reworded the Alter main query to use EXISTS rather than LEFT JOIN description: it changes how the SQL is written, never which products are shown.
- Clarified the Alter main query to use EXISTS rather than LEFT JOIN description: it changes only the front-end main query, mainly WooCommerce's product visibility clause, and lists what to check before leaving it on.
For the engineer evaluating this
Skip this if you just want the store to be quick. It is here because the person signing this off usually wants to know exactly what lands on the server.
- Index builds. Every build asks for
ALGORITHM=INPLACE, LOCK=NONEand falls back where a given index shape cannot be built in place. Verified against MariaDB 11.8.8, Percona Server 8.0.46-37 and MySQL 8.0.46, across every index shape the plugin creates, including prefixed columns, DESC and UNIQUE. A build that outlives the web request reports still applying and waits for the database rather than erroring. - Ownership. It only ever touches indexes it created, matched on its own prefix plus an ownership check. Deactivating the plugin leaves them in place; deleting it takes them out.
- Front-end weight. The bundled list-table copies, 118KB and 2,151 lines of PHP, are parsed only on wp-admin requests and under WP-CLI. Select2 is vendored rather than fetched from a CDN, and the settings screen loads no third-party fonts.
- Scope control. Any optimisation can be switched on at a named WordPress hook and off again at another, so it applies to one archive loop rather than the whole request. Registered as filters only.
- Headless.
wp spro recommendedandwp spro statusdrive the preset and report every managed index and outstanding setting, with dry-run, indexes-only and settings-only modes. The same operations are exposed to AI agents over MCP.
Frequently asked questions
ALGORITHM=INPLACE, LOCK=NONE where the database supports it and report real database errors; an index shape the server cannot build in place falls back to its normal build. Each optimisation can be controlled separately.wp-config.php. It needs our free Super Speedy Performance Analysis plugin, version 0.24.0 or later, and it installs an mu-plugin which is removed when you deactivate Scalability Pro. It is not offered on multisite.wp spro recommended applies the same preset, with dry-run, indexes-only and settings-only options. wp spro status lists every managed index and every recommended setting still outstanding, and wp spro options-scan, options-plan, options-apply and options-revert drive the autoload optimiser. The same operations are available to AI agents over MCP.Works well with
Some combinations get a bigger discount than others. Add this set to your basket to see its price.
34 reviews for Scalability Pro
Invest in Speed
Yearly plans include a year of updates and support and the plugin keeps working afterwards – renew at 30% off. Upgrade to a lifetime plan within 60 days and just pay the difference. Backed by our 60-day money-back guarantee.
1 Site
- Yearly licence – 1 year of updates and support, keeps working afterwards
- 1 Site License
- All optimisations & indexes
- 1 support seat – chat live with our engineers on Discord
5 Sites
- Yearly licence – 1 year of updates and support, keeps working afterwards
- 5 Site Licenses
- All optimisations & indexes
- 1 support seat – chat live with our engineers on Discord
25 Sites
- Yearly licence – 1 year of updates and support, keeps working afterwards
- 25 Site Licenses
- All optimisations & indexes
- 1 support seat – chat live with our engineers on Discord
- Priority support
5 Sites
- Lifetime licence – updates and support for life
- 5 Site Licenses
- All optimisations & indexes
- 1 support seat – chat live with our engineers on Discord
25 Sites
- Lifetime licence – updates and support for life
- 25 Site Licenses
- All optimisations & indexes
- 1 support seat – chat live with our engineers on Discord
- Priority support
250 Sites
- Lifetime licence – updates and support for life
- 250 Site Licenses
- All optimisations & indexes
- 2 support seats – chat live with our engineers on Discord
- Priority support
Start with the plan you need today.
If you need more sites later, move up without buying the plugin twice.
to try it properly
Ask for a full refund within 60 days of purchase, for any reason.
Upgrade and pay the difference
Within 60 days, your original payment counts in full towards a larger plan, including lifetime.
Example based on our €79 yearly and €279 lifetime plans.
Upgrading later? You still get credit after 60 days, though the credit reduces over time on yearly plans.
How do yearly renewals work?
A yearly licence includes one year of updates and support. The plugin keeps working after that. Renewal for further updates and support is optional. Renew before or within one month after expiry for 30% off, within six months for 20% off, or later for 10% off. Full terms
Agency or hosting company? Get in touch for custom pricing

Timothy L. (verified owner) –
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.
Darren E. (verified owner) –
Let’s be honest, a magic wand, set and forget?? I’ve seen so many plugins that promise the earth and then become one big mess of conflicting options that you need a physic degree to understand.
So how does Scalability Pro differ…
Install, index tables, select which options you want to be fast and those your happy with your current performance…
Wait five minutes and test…
On advice I installed the query monitor plug and didn’t just rely on GT Metric, however the results were plain to see, 11-12 seconds down to 2 seconds!!
And not only that, when I got involved in the Discord chat I was able to glean even more pearls of wisdom which has halved my autoload options and further streamlined my database, 10 years overdue…
Oh and conflicts with Caching….. None, I’ve got a pretty fierce set of Litespeed cache settings and the store doesn’t miss a heartbeat now!
10/10 would recommend!
Zlati Z. (verified owner) –
5 stars isn’t enough to mark how happy I am from the results of Scalability Pro! First of all – straight out of the box the plugin sped up my site a lot. After that Dave even helped me to further improve my site by helping doing some custom work for me. Overall the result is incredible – loading speeds went from almost 10 seconds to 1-1.5 seconds (my site has 500k posts and others). If it wasn’t for this plugin I was going to go for a fully built custom website which would cost me thousands! Thank you!!!
Avijeet (verified owner) –
Absolutely amazing and peace of mind. I was frustrated with the import speeds and as i have huge data to update daaily it was really very disapointing but after I installed this Plugin it worked like magic! I saw a speed boost of 4.5X! and plus the support is great too, Thanks to Dave and his plugin!
Fernando (verified owner) –
When I first installed the plugin, the difference in loading times was instantly noticeable. I was managing a WooCommerce store with 350k products, and the load times were painfully long. But after adding Scalability Pro, the speed boost was incredible! What used to take forever now loads in a fraction of the time.
If you run into any issues, whether it’s with the configuration or something that doesn’t work right away, there’s a great support community on Discord. They’re super fast to help out, and Dave is always there, ready to lend a hand. Any questions or problems I had were solved in no time!
Dave B. (verified owner) –
I have bought and activated the scalability pro plugin on our used machine listings site which comprises of 10 000s of listings and the plugin has made a huge difference in site performance and page load speed on the heavy pages. We have reduced the load time from 7 seconds down to 1 second and at times on certain pages down to .25 of a second.
Additionally, the plugin author makes himself available to chat with on discord usually daily. We couldn’t be happier.
David B
Sydney, Australia
Daniel Cyran –
Dawid is a true professional from whom WooCommerce experts could learn a lot. His solutions optimize WooCommerce to such an extent that even stores with hundreds of thousands of products run smoothly and without any lag. Moreover, Dawid is incredibly helpful – always open to solving issues and providing quick support on the dedicated Discord group. If you have a massive product database and struggle with WooCommerce performance, you should definitely try his plugins. They are professional, well-crafted, and make your store work as it should – fast and without problems. I highly recommend his plugins to anyone looking to take their store or marketplace to the next level!
Thomas J. (verified owner) –
I purchased Scalability Pro as an experiment to see how it affected WP ALL IMPORT. It managed to turn a 3 day stock sync process into a 1 hour process.
It has also sped up WooCommerce pages significantly.
I am now in the process of adding WP Scalability Pro to my other websites so they can benefit.
Marko H. (verified owner) –
This one saved my a$$!
I’m using it on large woocommerce (around 50K product variations). Improved import speed more then 3x. Thank you Dave and wpintense team!
Dave H. –
Thank you for your kind words!
Mark B (verified owner) –
Dave has made some tremendous products. Scalability pro is one of those. I didn’t think my project would work considering how many products I planned to have. Salability pro allowed me to upload 97,000 records. With Dave’s community and support I was able to make additional optimizations that helped me discover what was really required to boost the speed of my uploads and actually allow them to complete without failing. Check out his guides too for import speed, server configurations, and server optimizations. Now everything is fast. Excited for the future.
Dave H. –
Thank you for the review, I’m very glad we helped you out!
Jaime M. (verified owner) –
Use it to speed up you WP All Import and Woocommerce shop!
Mihai L. (verified owner) –
Recommend Scalability Pro if you have a lot of products and use wpallimport or wpallexport, improve import and export and also speed up your website.
Alessandro T. (verified owner) –
Dave made it right, we had express speed up in admin area. I almost gave up with woocommerce, but after this speed up we can definitely work smoothly. Thanks Dave
Dave H. –
Thank you for your kind review, we’ve worked hard on speeding up wp-admin. Got more speed boosts coming too for edit.php to make it even faster!
Silver P. (verified owner) –
Well. Very long story in short format.
I set up site for my client. All products are imported via XML / JSON from different wholesale warehouses. At the moment 26k total products / 18k in stock. With over 10k products and with Divi theme site started to slow down. Divi itself is quite heavy at these level because of per post / taxonomy templates and generating static assets per post / tax. Even if these Divi side optimizations are turned off, site is quite slow. So we started testing. Keep in mind – we had frontend assets optimized so LCP / FCP etc metrics were on par with that kind of structure. Biggest problem was on backend. For Google / GTMetrix it meant TBT (total blocking time) or as I understand – time for server to return data – that was around 12 seconds. Turned off Divi “performance” we got it 3 seconds down but still over 8 seconds.
So, here comes Scalabilty Pro. At first it was like – meh, i get it down to 3 seconds. Store became usable. More or less. But after wee bit tweaking and testing, combining with Perfmatters and WP Rocket – at the moment we sit TBT 10ms dektop / 10-700ms mobile. And we can use page preloading again which previously clogged down DB.
So, SSP only with indexes did a miracle on a site. With other tweaks admin pages are usable and site mostly works faster than small static pages.
And this all runs on shared web hosting at zone.ee server.
In another hand – Dave is awesome. Very fast support on Discord – explain problem and soon you have a solution.
Jeroen Biliet –
I’m super happy with this plugin!
We went from 30s product page load to 1s, which is marvelous for a product with 800+ variations.
One big reminder for myself and tip for others : LOG OUT OF WP-ADMIN!!! Being logged in also show the private and unpublished posts, which doesn’t give the plugin the chance to show its use!
Andrew G. (verified owner) –
I have been using Scalability Pro for a good few years now with no complaints. It’s a great plugin and has lots of great little optimisation settings that can really boost your speed on both the front and backend of your site. Our backend was getting really slow and would even crash sometimes when using it. Scalability Pro has helped with this tremendously.
The Discord server is very active and provides helpful and fast support too.
Konstantinos L. (verified owner) –
If you work seriously with woocommerce the most important things, that in each stage (development, launch, maintenance) gives you headaches are website-speed and performance.
Since my programming skills are not really great, I needed performance and filter plugins for my websites, which are not only fast, but also easy to add and use.
That’s why I took the risk and purchased the lifetime-performance-bundle superspeedy search, filters and scalability pro.
That’s it – much less headaches!
Thank you
Dave H. –
Thank you very much for your kind words! Glad to ease your performance pains.
Stephen O. (verified owner) –
Great plugin and great support thank you
Shawn T. (verified owner) –
Our current WP websites have been really laggy and despite switching to more powerful servers, we kept encountering bottlenecks until we found WPI.
We are currently using Super Speedy Search + Scalability Pro and it has been phenomenal with the performance improvements!
Across 2 of our websites on 1 server, we are looking at 90k MAU with 6k products total.
Dave has also been a great help with any bugs during the setup process – really speedy response and he sure knows what he is doing!
Daniel A. (verified owner) –
The plugin improved category loading and page display from over 15 seconds to 2 seconds instantly. Over 250,000 products on WooCommerce. The other pages are the same, this can be seen immediately, especially when there are more products on the page
Jay M. –
Super happy with Scalability Pro, the support, and the results – sped up my imports by multiples.
I first came across Dave and his work speeding up large WordPress/WooCommerce sites by watching his Wordcamp presentation on scaling Woocommerce – before he had this official plugin. Having all of that expertise distilled into a plugin, it’s pretty amazing and the results speak for themselves. A+++++
Rik E. (verified owner) –
Today put this tool on my website with 50,000+ products. The page loading times were really 10 to 20 seconds during imports via wpallimport. Set all steps and go through and now around 1 to 2.
What a great tool 🙂
Dave H. –
Thank you! This plugin was built for large stores or large blogs, so it’s really great to hear from happy customers.
Zaid I. (verified owner) –
BAD WEBSITE, BAD SUPPORT, BAD PLUGINS
I purchased the plugin, then I’ve installed it on my website and it did not do anything, literally nothing.
I’ve tried to contact the support and I did not receive any reply, Also I’ve tried to request a refund and no one contacted me.
This is a lie, be careful. DON’T DEAL WITH THIS WEBSITE.
Dave H. –
I’m never happy to hear about unhappy customers – I’m really sorry it didn’t speed things up for you.
Here’s a guide explaining what each of the plugins do:
https://www.superspeedyplugins.com/2018/06/30/wordpress-performance-quick-start-guide/
As for contacting us – please use the Q&A through the site and you will get a response – I don’t see any questions from you. I do not reply to email questions any more if that’s where you tried to contact me. This was an intentional decision to eliminate the vast number of questions I used to answer in private – now other customers can benefit from the questions and answers.
You can see my blog article discussing this here:
https://www.superspeedyplugins.com/2020/12/07/december-development-update/
If you are really in a rush, you can contact me through facebook, but if it’s a general question I’ll still ask you to ask the question through our Q&A system.
For refunds – email refunds@superspeedyplugins.com
I just looked through my emails and I see that your site crashed when you were creating the indexes – this is almost certainly due to your server running out of disk space. The indexes don’t take up too much extra space on your disks, but they do need some free space in order to be created.
John Black –
Hello!
I have a wordpress e-commerce website and woocommer. My website has about 100k products x 288 variants. And recently, I often don’t have access to line items. So does your plugin optimize that? Thank you very much!
Dave H. –
Yes, if you install Query Monitor, you’ll see a slow main query – it optimises those primarily. For the variations you should add Redis object cache – see my stack building guide: https://www.superspeedyplugins.com/2018/10/20/installing-the-fastest-wordpress-stack-ubuntu-18-mysql-8/
savvas z. (verified owner) –
I can’t praise enough this plugin. It helped me scale my woocommerce site. Importing products now it’s a breeze! Scalability pro cut the importing time to half (i am also using external images). Also my site loads much much faster than previously! Next stop: super speedy search and faster woo widgets.
If you want to scale your woocommerce site don’t miss Dave’s plugins. They are a must.
Thanks Dave
Joseph M. –
It took me almost a year to find this plugin. I can truthfully say it is without question a must have if you have any intensions of scaling woocommerce. Not to mention awesome support the few issues I had because of my theme were taken care of by Dave himself. Not only did he fix the small issues with my theme he took the time via my request to touch up my database while he was in there. Thank again I am thankful for your help and putting up with my relentless questions. Utmost respect – joe miller
cory d. (verified owner) –
This plugin is brilliant!!! Would give it 10 stars if I could. Brought the site loading times down to less than 2 seconds – was sitting at about 10 seconds before. Had a few problems with the configuration but the support was great and got me setup in no time. I highly recommend this plugin.
Harris –
Works very well, noticeable results immediately.
Paul A. –
My client site has about 10k products variations. Page loading time was around 10s, and by adding this plugin and doing a quick setup by following the guide, the WooCommerce pages now load in 2s. Still a bit more tweaking to do on my side with a few different options, but this plugin took my client site from being useless (yes a 10s load time for product pages renders your site useless!) to very useful 😉
Thanks for the great plugin and support!
Dave Hilditch –
Thanks Paul. It’s great to hear your feedback and I’m glad the plugin helps a lot. There’s more coming soon to shave more milliseconds off those page load speeds. In particular, I’ll be focusing on WP_Term_Query optimisations which are probably what are taking up the last of your slow load. (I consider 2s to still be slow)
Abhishek J. (verified owner) –
I bought the plugin a month back and I was impressed by Dave’s support, he is really knowledgeable. I had a product database of around 300k products which is also using wp-allimports custom fields functionality which made my postmeta database comprising of about 50 million rows.
Pros:
– This plugin creates indexes and has options to fix edit page issue in admin panel – I received when before, but when I started using scalability pro, it fixed it.
– My page load time for different categories decreased from 30 seconds to around 20 seconds with products around 100k which is great- all thanks to indexes created by the plugin
– Good support from Dave(the plugin was not working on my website, but Dave did do all the work manually on my website and recommended me a lot of stuff)
Cons:
– Scalability Pro is I think at its initial stages and it will improve gradually. Different theme support and good service in future can sustain. The reason I’m listing this is because when I started using this plugin, my product database tripled, but it was fixed with in 2 days by Dave when I told him, so if you’re having high traffic I would recommend to test it on your test site before making it live.
– It won’t necessarily solve all the problems, I still can’t use filters on Products section(where I can see all the products) in wp-admin section, so you will be using it like a usual customer only or if you’re technical you can go to MySQL database, see your products. It should have solved this problem
– Filters provided by scalability pro don’t work, I have raised issue with Dave but not fixed yet. Filters also don’t support wp_postmeta fields or custom fields. I really don’t like to message him for everything, it should have been solved.
– I think search still doesn’t use Match .. Against(default wordpress search) or as a matter of fact on any pages.. I analysed it using query monitor but it still seems to use Like only. No support for custom fields. Other problem is created by wp_postmeta table(as all the extra fields related to product are in wp_postmeta) Wp_posts table is not that big a deal, as only 1 row is created per product while in wp_postmeta around 16-20 rows are created per product, so either you’ll have to write custom search. If custom search was there with this plugin, you could really see performance improvements in your site(I’m not ignoring the performance improvements but they are not noticeable for me as my search dependence is on wp_postmeta table and category page loads under 20 seconds, which should have been under 2 seconds). Dave talked about releasing beta version for custom search but still isn’t released yet.
I am waiting for updates on this plugin and hopefully errors I listed will be solved in future. All in all I would recommend to go with this plugin, it will offer you useful insights about your website and hopefully if you’re a wordress programmer, you can solve those or if you aren’t, you can always hire Dave or other programmer.
This plugin offered me a ray of hope that I don’t have to discard my wordpress website and go with Magento(if you read it on stackoverflow, everyone would recommend agianst wordpress for products with large database). If you’re programmer or your programmer can understand the way plugin works and take it from there instead of relying on Dave, this is great product.
Thanks
Dave Hilditch –
Hi – thanks for the detailed review.
Regarding missing filters – there was a bug introduced in the last version which caused this error on some setups, to do with adding the manual sorting functionality.
A fix has been coded up and is ready to be deployed, I’m just adding compatibility with the WooBrands plugin before I deploy.
re: Match against search (instead of like) this functionality was removed from Scalability Pro and has been added to a separate plugin called Super Speed Search which everyone who has purchased Scalability Pro to date will get for free. This new plugin is almost ready and is so fast that the search results update using ajax as you type (tested on 800,000+ product reference site).
Sorry about the delay with these releases – I’ve been working on making super speedy search as compatible as possible with as many themes as possible.
Aaron M. (verified owner) –
Our website over at nyde.co.uk was under development and suffering from a complete slowdown. I purchased Scalability Pro in the hope that it would give things a much needed boost, but didn’t expect the results to be quite as brilliant as they were. Dave worked with me to configure the plugin and also identified numerous bottlenecks on my website. The improvement is unbelievable! Really pleased with my purchase and I couldn’t recommend Scalability Pro or working with Dave on performance enhancements enough.
Istvan D. (verified owner) –
The Scalability Pro plugin and Dave’s support is simply amazing! I was struggling with 30+ seconds load times on my shop and the plugin alone has reduced this under 3 seconds. Wow! This plugin and generally everything around WPIntense is absolutely recommended!
Erik D. (verified owner) –
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.
Dirk (verified owner) –
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.