Description
Scalability Pro is the core Super Speedy Plugins optimisation plugin – your performance insurance plan for everything except search and filters. As the team completes performance analysis jobs for clients, and answers customer performance questions on the Discord server, new optimisations for various themes and third-party plugins are added straight into Scalability Pro. The only thing it cannot fully optimise is search and filters, which is why Super Speedy Search and Super Speedy Filters exist to complement it.
Note: Scalability Pro will not speed up a tiny site. It will, however, let a small site grow large without slowing down. It works best alongside Super Speedy Filters and Super Speedy Search.
See it running live: a demo store with almost 1,000,000 products on a $20/month server with no page caching – foundthru.com/shop.
“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.”
Thomas Jarvis
“The plugin improved category loading and page display from over 15 seconds to 2 seconds instantly. Over 250,000 products on WooCommerce.”
Daniel Antoniów
“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.”
Jeroen Biliet
What Scalability Pro does for you
- Speeds up wp-admin, imports and main queries – and really everything outside of search and filtering.
- Future-proofs your website. A scalable site does not slow down as it gets bigger.
- Reduces server cost. It speeds up many slow SQL queries that run through WP_Query, such as the main query on your archive pages (shop, posts or custom post types).
- Easy to use. One-click custom indexes, automatic front-end query rewrites and options to disable unused wp-admin features to speed up your back end.
- Saves time. Includes optimisations to speed up imports and exports.
- Speeds up slow themes. Includes optimisations for themes such as Avada, and speed boosts discovered through the Performance Analysis Service.
- Good for Googlebot, admins and users. Speeds up imports, archives, wp-admin, XML sitemaps and slow themes.
- Stop worrying about performance. Purchase includes access to the Discord server so you can chat directly to Dave Hilditch about your site performance.
What this gives you back
- Your site stops slowing down as it grows. A scalable site serves a page as fast with 1,000,000 posts as it does with 10,000, so you can add products and traffic without dreading the slowdown.
- Faster imports, quieter server. Typically around a 10x boost on large imports, with lower CPU while they run, so your shoppers are not affected while you update stock.
- A faster back office. wp-admin lists, product screens and quick edits stop crawling once your catalogue is large.
- Lower hosting bills. Fixing the slow queries means you stop paying for a bigger server to paper over them.
- No more performance firefighting. You get direct Discord access to Dave, and every fix made for a client goes back into the plugin.
Performance versus scalability
Performance is how quickly your webpages load. Scalability is how many simultaneous users you can have on your website without crashing. Scalability Pro focuses on scalability, so it is not touching the front-end JavaScript or CSS.
However, the primary technique to improve scalability is to fix performance so that it does not degrade as your site grows. This means that if you already have a large website, you will see a big performance boost by using Scalability Pro.
How we make WordPress scalable
- Makes WP_Query lightning fast – 0.4 seconds uncached versus over 180 seconds for 820,000 products on the /shop/ page.
- Optimises your underlying database and queries and eliminates table scans.
- Provides options to alter or remove slow WooCommerce and WordPress features.
- Complements caching systems perfectly.
- Speeds up slow queries. Install the free Query Monitor plugin and view your slowest pages – if you see slow queries reported, Scalability Pro will help. If you instead see thousands of queries occurring, you probably need Super Speedy Filters too.
- Adds indexes to your key WordPress tables to help optimise underlying SQL queries.
- Alters database queries to make them more efficient, avoiding table scans.
- Provides options to disable, alter or microcache slow WordPress, WooCommerce and import functionality.
If Scalability Pro is implemented and there are still table scans occurring, we will fix them.
Every optimisation included in Scalability Pro
Scalability Pro is a toolbox of individual optimisations you can toggle on and off. Here is what is included and what each one speeds up.
Front-end query speed
- Custom database indexes – one-click indexes for wp_posts, wp_postmeta, wp_term_relationships and more, so archive, meta and taxonomy queries use an index instead of scanning the whole table.
- Remove SQL_CALC_FOUND_ROWS – stops MySQL counting every matching row just to work out how many pages there are, which is the main cause of slow archive pages on large sites. Optionally replaces the page count with the word “Many”.
- Rewrite LEFT JOINs to WHERE EXISTS – converts the taxonomy and meta joins in your main query into EXISTS subqueries, which MySQL runs far more efficiently at scale.
- Remove CAST on wp_postmeta – removes the CAST() wrapper that stops MySQL using the index on meta_value.
- Optimise WooCommerce GROUP BY – drops redundant GROUP BY and DISTINCT when only post IDs are being selected.
- Remove sort options – skips a slow ORDER BY on very large custom post type archives where the sort order is not needed.
- Remove the private items check on the front end – avoids an unnecessary post-status check for logged-out visitors.
- Custom query alterations – define your own hook-based query rewrites for edge cases specific to your site.
wp-admin speed
- Cache author counts – caches the per-author post count that WordPress recalculates on every Posts and Products screen.
- Cache user counts – caches the role counts shown on the Users screen.
- Cache the product category dropdown – caches the product category list on the Products screen so your quick edits stay fast.
- Remove the WooCommerce order summary widget and disable the Marketplace suggestions – removes dashboard elements that run their own queries.
- Ajax attribute editing – loads product attribute terms on demand instead of all at once.
Imports and exports
- Cache post counts – caches the post-status counts that WordPress and WooCommerce recalculate repeatedly during imports.
- Defer term counting – counts terms once at the end of an import rather than once per row, which is the single biggest import speed boost for large catalogues.
- Optimise product attributes lookup – removes a redundant clause from the WooCommerce attribute lookup query.
- Avoid expensive WP All Export meta_key enumeration – prevents or caches the full wp_postmeta scan WP All Export runs to list your meta keys.
- Optimise Action Scheduler – trims Action Scheduler retention so completed and failed actions do not pile up and slow your site down.
WooCommerce bloat
- Fix the WooCommerce onboarding query – replaces a slow post-status COUNT that runs on new installs.
- Remove the custom-meta select box query – replaces a full wp_postmeta scan used to build a meta dropdown.
- Optimise WooCommerce updates – rewrites the WooCommerce transient cleanup so it can use an index.
- Fix the Order Delivery Date plugin admin query – caches its slow year and month grouping query.
- Cache the WooCommerce and Flatsome product-grid shortcodes – caches the output of these product grids so they are not rebuilt on every page load.
- Switch off phone home – blocks unnecessary outbound HTTP calls that other plugins and themes make, which can add seconds to your admin pages.
Diagnostics and housekeeping
- Slow Query Log – records your slowest queries along with their stack traces so you can see exactly what is slow and where it comes from.
- Remove image sizes globally – stops WordPress generating image sizes you do not use every time an image is uploaded or imported.
Add-on: Super Speedy Listings
Super Speedy Listings is an optional add-on for Scalability Pro. It pre-computes term relationships into an optimised lookup table so author archives, taxonomy archives and filtered listings resolve from a single indexed table instead of large joins. It is available to download for customers with an active licence.
Five key problem areas for scalability
Scalability Pro helps speed up your main slow queries, adding indexes to tables and rewriting queries to use them. But it cannot do everything on its own. If you install the free Query Monitor plugin and view your slow pages, you will see one or more of these causes.
Slow queries as your site gets bigger
This is what Scalability Pro helps with. It makes slow queries run quickly when your site is bigger. Some slow filtering and search queries cannot be optimised by Scalability Pro. If the slow query uses WP_Query, Scalability Pro can optimise it.
Too many queries
This problem most often comes from badly coded search or filtering plugins. The Redis object cache sometimes helps with this a bit, but we recommend you check out our Super Speedy Search and Super Speedy Filters plugins.
Too much RAM and CPU consumption in PHP
In Query Monitor, you will see low SQL time, low numbers of queries, but long page generation time and large RAM usage. If you order queries by row-count, you will find some queries that return large row counts, often over 5000 rows even though there are not 5000 items displayed on your page. The offending plugin on your site is filling PHP objects with those 5000 rows on every page load. Often, this can be fixed by implementing an object cache – but it depends on the type of data. We have seen WOOF filters do this kind of bad behaviour on numerous client sites once they get more than a couple of thousand items.
Slow API or ajax calls
Your site may be using ajax, or it may be calling third-party APIs. Scalability Pro has a big upgrade coming to transform the speed of ajax calls from many third-party plugins.
Poor hosting
Make sure you get a good quality hosting stack. PHP 7, MySQL 8, or MariaDB, nginx or Litespeed, redis in-memory-only and a proper configuration.
Scalability Pro transforms import speeds
Depending on how large your imports are, you will get phenomenal improvements in import speed. We optimise item lookup to make it instant for importing tools to decide whether to update or insert an item, and we defer term counting so that the expensive operation of counting items per category is done at the end of the import, not once per row.
Typically, users see something in the region of a 10-fold speed boost in their imports, along with reduced CPU usage while importing, which means your users are no longer negatively affected by simply updating your products with your import.
Super Speedy Plugins are ‘Speed Junkies’
We have been called many things, but our favourite is ‘Speed Junkies’. Our founder, Dave Hilditch, transformed the scalability and speed of Skyscanner (a billion dollar website now) and now focuses on making WordPress the fastest CMS on the planet.
Support is incredible
We have an active and growing Discord server for all customers where you can come ask any questions you have and get help for anything you need.
Don’t take our word for it
Here’s a video made by one of our customers
In the video, they talk about both Scalability Pro and Super Speedy Search.
Scalability Pro demo
You can see the speed of a demo and dev site on a $20 per month Digital Ocean server with no page caching enabled. It has almost 1 million products, but it is also our test bed for plugin alterations so you may see the style and features available on the demo changing – also, please forgive the missing images on many products, which are not plugin-related: foundthru.com/shop.
Please note that the above shop also has our Super Speedy Filters and Super Speedy Search plugins activated. You can buy all three of these plugins together at one low price in our Super Speedy Plugin Pack.
What can’t Scalability Pro do?
Scalability Pro is a true must-have plugin for speed, scalability and growth, but there are some things it cannot do.
It won’t fix your hosting
It cannot fix your hosting. If you have bad hosting, you can follow our latest stack building guide.
It won’t fix your slow WooCommerce filters
Every WooCommerce filters plugin we have tested is badly coded when it comes to performance and scalability. It is too complicated inside a single plugin to fix all of those issues for other filtering plugins, so instead we have created our own filtering plugin. If you have slow WooCommerce filters then you need Super Speedy Filters.
It won’t fix 1000s of product variations
1000s or 100,000s of product variations lead to slow product detail pages and slow archive pages where those products exist. We cannot optimise these because technically the queries are fast – the slow part is that product objects are created and stored for each variation, and this uses PHP CPU and RAM. There are options to improve this:
- Use an object cache – an object cache allows these PHP-built objects to be reused again wherever they appear on your site. Redis or Memcached are good choices. If your hosts cannot help, move to better hosts who understand these basics.
- Use Product Rules – often, variations end up being used because they are a default feature of WooCommerce when Product Rules would have been better. If choosing an option for a product changes the price by a consistent amount – for example, Option A adds £10 – then Product Rules can be used and you can eliminate 1000s of variations.
- Use Product Addons – if particular options are available across all variations, these can be created as Product Addons. For example, gift wrapping, engraving and more can be addons rather than variations.
You may already have benefitted from our work
We regularly submit code optimisations to other plugin and theme creators so they can speed up their creations. If you use the Yoast Sitemaps or the Yith Wishlist plugin, amongst others, you have probably benefited from our work in the past.
We are trying to improve performance and scalability across the board, but by owning Scalability Pro you get these optimisations first and you get our incredible support to help with your specific issues.
Proof that we know what we’re doing
Here is a selection of in-depth case studies where optimisations ended up inside Scalability Pro:
- Speeding up imports
- Theme speed boosts
- General speed boosts
- Optimising XML sitemaps
- Optimising Yith Wishlist
Never worry about WordPress performance or scalability again
We are speed junkies. We hate slow. We regularly provide performance optimisations to other plugin developers, but by making the smart choice to buy Scalability Pro you will never have to worry about performance again. Grow your WordPress site with no limits, no worries, and focus on your business – let us focus on performance and scalability.
Scalability Pro Knowledge Base
View full Knowledge Base →What's new in Scalability Pro?
View full changelog →- Added a "Recheck Licenses" button above the licence table on the Super Speedy Settings page so customers have a clear way to refresh licence status after a renewal or upgrade without scrolling down to the licence-key field. The button is disabled until a licence key is entered/saved and re-enables as you type.
- The Recheck flow now also force-bypasses the auth-server's own 1-hour licence cache (via a `force=1` flag on the `wpiapi/check_product_key` call), so renewals/upgrades that completed less than an hour before a recheck no longer show as expired/exceeded. Normal admin page loads continue to use both caches as before — only an explicit Recheck click bypasses them. (Lives in the `super-speedy-settings` submodule, so the change propagates to every Super Speedy plugin.)
- Security: added capability checks and nonces to every admin AJAX endpoint that was previously reachable by low-privilege or unauthenticated users (slow query log fetch, index create/drop/drop-all, symlink create/delete, wp-config rewrite, slow query log truncate, term recount, profiling results save, cache clears, settings export/import, CSV export, action scheduler maintenance, and the WP All Import diagnostic helper)
- Security: removed `wp_ajax_nopriv_*` registrations from the slow query log fetch and the post-count / author-count cache clear endpoints — these were admin-only operations that should never have been exposed to unauthenticated visitors
- Security: escaped every column rendered in the Slow Query Log admin table (`time`, `url`, `query`, `stacktrace`, `duration`) — prevents stored XSS via a poisoned slow-query log entry being executed when an admin views the tab
- Security: fixed the "Create symlink" button, which previously created a dangling `wp-content/db.php` (the source path the button used had never existed in the plugin) and would have fatal-ed the site on the next request; the slow-query drop-in (`db.php` + `profiling-queries.php`) has been moved into `tabs/slow-query-log/wp-content/` to match the path the button always expected, every readlink check across the tab now derives the path from `plugin_dir_path(__FILE__)` so it works regardless of the plugin's installed folder name, and the symlink source is validated with `is_file()`/`realpath()` before linking
- Refactored: the slow-query-log drop-in files now live under `tabs/slow-query-log/wp-content/` so the tab is self-contained ahead of the planned split of each tab into a separate add-on plugin
- Security: hardened `spro_search_terms` (product attribute search) — requires `edit_products` and null-checks the taxonomy so PHP 8 no longer fatals on an unknown taxonomy
inkoop (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 Cowley (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!
piltchev (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 Brickman (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 Jarvis (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 Hrnjak (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 Hilditch –
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 Hilditch –
Thank you for the review, I’m very glad we helped you out!
Jaime Martinez (verified owner) –
Use it to speed up you WP All Import and Woocommerce shop!
Mihai Lapugean (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 Trotta (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 Hilditch –
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 Pik (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!
David Graham (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 (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 Hilditch –
Thank you very much for your kind words! Glad to ease your performance pains.
Stephen OConnor (verified owner) –
Great plugin and great support thank you
Shawn Tjai (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 Antoniów (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 Engelen (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 Hilditch –
Thank you! This plugin was built for large stores or large blogs, so it’s really great to hear from happy customers.
Zaid Iseed (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 Hilditch –
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.dev.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.dev.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@dev.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 Hilditch –
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.dev.superspeedyplugins.com/2018/10/20/installing-the-fastest-wordpress-stack-ubuntu-18-mysql-8/
savvas (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
joe.digitalocean –
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 (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 Jain (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 Magnus (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 (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 Dalgaard (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.