The Scalability Pro Plugin is the core WP Intense plugin to transform the speed and scalability of your WordPress site.
It’s NOT a caching plugin – what it does is speed up your site by optimising your database (using indexes) and optimising the queries made against your database under the hood. This makes *everything* faster, even without caching.
WooCommerce and Custom Post Types have many occasions where table scans occur against the database. That means the plugin is reading every item in your database. When you only have a few hundred products in your WooCommerce store, you would never notice. But once you get to a few thousand or tens or hundreds of thousands this becomes dreadful for your server.
The Scalability Pro Plugin adds useful indexes to your core tables and then alters the queries without changing the functionality so that these indexes can be used. What that means is the queries use the indexes for data retrieval instead of reading every page and what that means is your site becomes FAST and SCALABLE.
On installation, the plugin will set up and configure your database indexes so make sure you have your timeouts set high enough for this one-time operation.
The plugin works by spotting slow queries and altering them to take advantage of database indexes – meaning everything FLIES!
Also included in the plugin are replacement WooCommerce filters which provide the same functionality and in many cases better functionality than the vanilla WooCommerce filters.
- Layered Nav Widget replacement (categories and attributes)
- Recently viewed products (Ajax) widget replacement
- Price filter widget replacement
This plugin fixes database queries for WooCommerce and/or Custom Post Types and gives you replacement widgets.
- Install the plugin and activate it – make sure you have your page timeouts high enough for the index creation process on activation
- Visit Settings->Scalability Pro Plugin and choose your options
- (optionally) Navigate to Appearance->Widgets
- (optionally) Add the Scalability Pro plugin widgets and use them to replace any existing WooCommerce filters you may have
- Measure performance before and after using the Query Monitor plugin. Also useful to test performance of various options.
You can see the speed of a live site using this here: http://www.homes-abroad.net/ and a demo/dev site here (with 817,000 products, but dev, so not guaranteed up all the time): http://www.foundthru.com/shop/