Scalability Pro 5.81

= 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

= 5.09 (7th April 2023) =
* Improved speed of 'Remove check for private items' option - moved it from the 'query' filter to the pre_get_posts filter - this reduces CPU usage on sites with high query counts
* Fixed 'Remove Sort Order' and 'Remove SQL CALC ROWS' options so that they operate on taxonomy langing pages as well as filtered archives
* Added new Ajax search capability for when editing a products attributes - helps if you have a lot of terms
- We had a client with 100,000+ terms in an attribute (artists of a song)
- WooCommerce loads all 100,000+ of these artists into the HTML select box on the Edit Product page
- this makes the initial page load very slow AND it makes the page react really slowly because there is so much HTML for the browser to process
- the new option here transforms that dropdown into a box which shows the first 10 then you can search to find others
* Added fix for WooCommerce onboarding - this speeds up wp-admin on our foundthru site from 10s to 1s in most cases, and from 70s to 1s in some cases!
- Woo Onboarding uses the has_products function which for some stupid reason performs a table scan
- this check IS cached, but if you edit any products and/or are performing imports then this cache would be wiped and you'd be immediately back to slow performance
- we have added a separate 24 hour cache so that even if you are running imports this simple check for has_products() will be intercepted and return true
* Added new Import Tab option to reduce the number of image sizes generated
- by default, WordPress creates images in all registered sizes
- this could mean you have 20+ images being generated in different sizes on your server when you upload a single image - this uses excessive disk space and CPU
- this new option adjusts WordPress so only the images you choose get created
* Added new index for use by Rankmath on wp_rank_math_analytics_objects table on object_id - speeds up rankmath analytics
* Added new index on posts on post_modified_gmt

= 5.05 (4th November 2022) =
* Previous fix confirmed - updated settings page to instruct users to add define('SPRO_FIX_WOO_ONBOARDING', true); to wp-config.php if they wish to test this option

= 4.92 (3rd October 2022) =
* Finally found the real issue - there was an uncommitted change in SSS to overrule Spro sort order and there was an incorrect rule to only remove sort order for products, and the check for main query had been removed. All fixed.

= 4.87 (29th September 2022) =
* Fixed Remove Sort Order option - it was not correctly removing the default sort order from the products archive. It should only remove the sort order if there is no URL orderby parameter to override the default.