Scalability Pro 5.52

= 5.52 (11th April 2024) =
* Updated stored reference list tables from WP updates
- hopefully this doesn't need to happen too often, maybe I could just reference the constructor of the parent somehow to run the hash check

= 5.44 (10th January 2024) =
* Version number bumped for new deployment system test

= 5.42 (21st November 2023) =
* Updated plugin updater to look at superspeedyplugins.com

= 5.39 (15th November 2023) =
* Added new SPRO_PREVENT_WPAI_DUP_CHECK definition
- setting this to true can help speed up WP All Import if you have large imports
- this seems to be dependent on your config for your 'unique key' which is normally automated
* Fixed bug with fixing Woo Onboarding code
- the has_products function was fixed previously, now the is_new_install is properly fixed
- previously the fix had only been added to some admin pages, this fix now stops that slow code running on WP All Import batches too
* Altered wp-admin > Optimise Woo products list to instead Remove Woo Product Category dropdown
- the code previously altered the code to only list the first level of categories, but was no longer working
- now this code just removes that dropdown completely
- with the recent update to Super Speedy Search you can search for categories instead

* Improved Slow Query Log so it captures info more reliably
* Fixed bug that prevented slow query log running if no db.php existed

= 5.34 (13th October 2023) =
* Option to cache post counts for admin pages created
- this has been separated out from defer term counts as a separate option, but it's still in the import tab because it helps most with admins running imports a lot
- option has also been updated to exclude shop_order post types from the cache since order statuses change frequently and admins need to see what items remain to be done

= 5.28 (17th September 2023) =
* Fixed bug in switching off slow sql profiling

= 5.24 (22nd August 2023) =
* Added new detection of unnecessary GROUP BY when LIMIT 0,1 is being used
- this seems to happen in imports and causes a table scan of wp_posts, so this should result in a good boost for imports on large sites
* Added further improvement for 'defer term counting'
- when a new item is published, that post types cache is wiped
- this leads to slower imports since an entire recount can happen after every import
- The change has modified this query to fetch data from our own cache table which stores the counts for 24 hours if you enable the defer term counting option
* Added Optimize Product Attributes Lookup functionality to the Imports tab
- WooCommerce maintains the product attributes table EVEN IF you deselect to use it
- One outstanding issue here on larger sites is the SQL where they check WHERE product_id = 984353 OR product_or_parent_id = 984353;
- only the product_or_parent_id needs to be checked in this case and then an index gets used
- This functionality alters this SQL query if you enable the option on the Imports tab

= 5.18 (10th August 2023) =
* Hotfix for new updates system - if your server was configured to disable remote URL requests, a critical error was happening upon upgrade. This has been fixed with a warning message that you cannot check for updates.

= 5.11 (22nd June 2023) =
* Fixed bug in reducing storage of action scheduler items
* Added new Beta SPRO_CACHE_PMXE_META_KEYS option
- to enable, add define(SPRO_CACHE_PMXE_META_KEYS, true); to your wp-config.php
- when exports start with WP All Export, it counts the unique meta keys in your table
- on large sites, this can be a pain