Skip to content

Installation instructions for the Scalability Pro Plugin

Below you can find instructions on how to install and configure the Scalability Pro Plugin.

After purchasing the Scalability Pro Plugin, you will receive a zipped file, from there, please follow these steps:

In your WP admin area, click on “Plugins” -> Add new -> Upload Plugin -> Choose file. From there you can select the zipped file you selected and install the Plugin.

addnew

Configuration:

There are many options in the settings page, but don’t let that scare you. The most important first step is to create your indexes.

B-tree indexes on the correct columns along with some SQL modification speeds up all your archive pages as well as imports especially when your imports get larger and your import needs to check for existing items.

Archive pages include all your WooCommerce shop pages, your ‘latest posts’ page and your category pages.

Visit Settings -> Scalability Pro and click the big button to create your indexes.

Note: Creating the indexes may time out – refresh the settings page to view progress and click to create them again if you have to – it will continue from where it left off until all are created.

Configure options

Read through each option text carefully to figure out if you can remove this piece of functionality. Some shops & sites need more or less than others. The more you can remove, the more scalable your site will become.

Did this article answer your question?

10 Comments

  1. Tim Rujan


    July 17, 2019 @
    2:40 pm

    I lost my cart and can’t get it to work after installing your plugins..
    I know it’s got to be something I’m overlooking.

    Reply

    • Dave H.


      July 17, 2019 @
      6:28 pm

      Switch off the experimental option in Scalability Pro.

      Depending on your plugins you’re using, you may have to switch off the ‘remove ordering’ option in Scalability pro too.

      Reply

  2. Mathew T.


    May 8, 2020 @
    12:55 pm

    Hi Dave,

    Can I ask if this plugin is compatible with a multisite installation and if so, should the plugin be activated on a network level or per individual site?

    Many thanks,

    Mathew

    Reply

    • Dave H.


      May 8, 2020 @
      3:25 pm

      [EDIT: Scalability Pro was made multisite compatible quite a while back]

      Hi – it’s not yet multisite compatible because the index names when created at each invidivual site would not be unique.

      If this is a priority for you, I can bump the request up the list.

      I’ve created a trello card for this job here:

      https://trello.com/c/vV0o8XTc/97-spro-make-scalability-pro-multisite-compatible

      It would be great if you could add any extra comments about how you’d like to see it administered – would it be better to have it setup and configured at the network level or to give site-owners the job of creating the indexes? I presume network level would be best? You can add comments directly onto the Trello card.

      Reply

  3. Andy


    June 29, 2020 @
    7:59 am

    Hi.

    Would this plugin work with woocommerce products on a custom page (elementor) that are in a product table (barn2media)? Currently the category has over 20k products and is slow when applying filters and initial page load etc

    Thanks

    Reply

    • Dave H.


      June 30, 2020 @
      2:03 pm

      You should look at http://www.wpintense.com/performance/ for a guide to which plugin improves which thing.

      If you have query monitor installed, you can check and see if your main query is slow – if it is, Scalability Pro will help.

      However, you’re saying the filters are what is causing slowdown so it’s highly likely you need Faster Woo Widgets instead.

      Reply

  4. Freddy


    September 18, 2020 @
    3:09 pm

    I just purchased your plugin but don’t know how where to start. I have a new woocommerce installation and a csv file with ~3 million products to import. Each product has about 75 meta keys. Will scalability pro optimize my import if I do it through a custom script? Do I have to use WordPress or woocommerce importer? Am I supposed to use the default postmeta table or is it better to use a custom data store?

    Reply

    • Dave H.


      September 23, 2020 @
      3:10 pm

      The primary part Scalability Pro optimises for imports is checking against wp_posts or wp_postmeta for existing data – i.e. should the import update or insert.

      So, it depends on your custom import script – I can recommend the WP All Import plugin – one-off license fee and it works with any size of file.

      Reply

  5. David


    May 13, 2021 @
    12:14 am

    I am looking to buy Scalability Pro.

    I have a site with ~1500 products and 40k+ orders. Will the indexing process slow the site down or cause any issues during this process? How long does it take?

    In other words, can I just install and configure it without problems, or should I wait for a quiet time in the store? I can’t afford to compromise site performance during busy periods.

    Reply

    • Dave H.


      May 13, 2021 @
      12:49 am

      WooCommerce orders are stored in wp_posts, so yes it’s best to create the indexes at a quieter period. With 40,000 orders, and 1500 products, your wp_posts table is probably only 100,000 rows or fewer though. It’s your wp_postmeta table that may take a little longer, it might be as many as 1 million rows. Even then though, the indexes for 1 million rows take a few seconds. With MySQL 5.6+ (hopefully you’re on MySQL 8 right?) then CREATE INDEX statements (that Scalability Pro uses) are non-blocking. They are CPU and disk heavy though, so create the indexes at night if you’re worried.

      The best approach would be for you to apply the indexes on your staging environment – a clone of your live – and then you’ll see how quickly they get created.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *


No Comments

  1. Tim Rujan
    July 17, 2019 @ 2:40 pm

    I lost my cart and can’t get it to work after installing your plugins..
    I know it’s got to be something I’m overlooking.

    Reply

    • Dave H.
      July 17, 2019 @ 6:28 pm

      Switch off the experimental option in Scalability Pro.

      Depending on your plugins you’re using, you may have to switch off the ‘remove ordering’ option in Scalability pro too.

      Reply

  2. Mathew T.
    May 8, 2020 @ 12:55 pm

    Hi Dave,

    Can I ask if this plugin is compatible with a multisite installation and if so, should the plugin be activated on a network level or per individual site?

    Many thanks,

    Mathew

    Reply

    • Dave H.
      May 8, 2020 @ 3:25 pm

      [EDIT: Scalability Pro was made multisite compatible quite a while back]

      Hi – it’s not yet multisite compatible because the index names when created at each invidivual site would not be unique.

      If this is a priority for you, I can bump the request up the list.

      I’ve created a trello card for this job here:

      https://trello.com/c/vV0o8XTc/97-spro-make-scalability-pro-multisite-compatible

      It would be great if you could add any extra comments about how you’d like to see it administered – would it be better to have it setup and configured at the network level or to give site-owners the job of creating the indexes? I presume network level would be best? You can add comments directly onto the Trello card.

      Reply

  3. Andy
    June 29, 2020 @ 7:59 am

    Hi.

    Would this plugin work with woocommerce products on a custom page (elementor) that are in a product table (barn2media)? Currently the category has over 20k products and is slow when applying filters and initial page load etc

    Thanks

    Reply

    • Dave H.
      June 30, 2020 @ 2:03 pm

      You should look at http://www.wpintense.com/performance/ for a guide to which plugin improves which thing.

      If you have query monitor installed, you can check and see if your main query is slow – if it is, Scalability Pro will help.

      However, you’re saying the filters are what is causing slowdown so it’s highly likely you need Faster Woo Widgets instead.

      Reply

  4. Freddy
    September 18, 2020 @ 3:09 pm

    I just purchased your plugin but don’t know how where to start. I have a new woocommerce installation and a csv file with ~3 million products to import. Each product has about 75 meta keys. Will scalability pro optimize my import if I do it through a custom script? Do I have to use WordPress or woocommerce importer? Am I supposed to use the default postmeta table or is it better to use a custom data store?

    Reply

    • Dave H.
      September 23, 2020 @ 3:10 pm

      The primary part Scalability Pro optimises for imports is checking against wp_posts or wp_postmeta for existing data – i.e. should the import update or insert.

      So, it depends on your custom import script – I can recommend the WP All Import plugin – one-off license fee and it works with any size of file.

      Reply

  5. David
    May 13, 2021 @ 12:14 am

    I am looking to buy Scalability Pro.

    I have a site with ~1500 products and 40k+ orders. Will the indexing process slow the site down or cause any issues during this process? How long does it take?

    In other words, can I just install and configure it without problems, or should I wait for a quiet time in the store? I can’t afford to compromise site performance during busy periods.

    Reply

    • Dave H.
      May 13, 2021 @ 12:49 am

      WooCommerce orders are stored in wp_posts, so yes it’s best to create the indexes at a quieter period. With 40,000 orders, and 1500 products, your wp_posts table is probably only 100,000 rows or fewer though. It’s your wp_postmeta table that may take a little longer, it might be as many as 1 million rows. Even then though, the indexes for 1 million rows take a few seconds. With MySQL 5.6+ (hopefully you’re on MySQL 8 right?) then CREATE INDEX statements (that Scalability Pro uses) are non-blocking. They are CPU and disk heavy though, so create the indexes at night if you’re worried.

      The best approach would be for you to apply the indexes on your staging environment – a clone of your live – and then you’ll see how quickly they get created.

      Reply