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?

8 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

      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

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

      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

Black Friday!

This is the only time of year when we have our biggest discount ever!

Use coupon code BF2020 for a massive 50% discount.

Get 50% off any plugins or plugin packs! Use coupon BF2020. First 100 only.

We use cookies

We use cookies for various things on our site, including our on-site chat bubble (if you use it), our comment forms (if you use them) and for session handling (if you log in).

Other than that, we use cookies to identify where traffic came from to help us understand which traffic turns into sales, we use a cookie for Google Analytics traffic analysis and we use a cookie to customise adverts for our own products we think you'll be interested in.

You can read more detail in our privacy policy page. Please click 'Accept' or 'Decline' to continue.