WooCommerce database format finally fixed
Anyone running a larger WooCommerce shop knows the amount of custom... well, "fiddling" is the right word, needed to keep it running smoothly.
With WordPress' blogging roots, it was built to use posts database entries for the products as well. For years, this has been the Achilles' heel of WooCommerce as a web-shop platform.
Now, in October 2023, WooCommerce has introduced the "High-Performance Order Storage" or HPOS (IT people just love acronyms ).
This creates new database tables (with their own indexes) for storing the orders information. WooCommerce is now performant and scalable (for huge shops) out-of-the-box.
In my experience with a few existing shops, the update to the new system went smoothly.
Some more details about this can be found on the WooCommerce blog:
https://woocommerce.com/posts/platform-update-high-performance-order-storage-for-woocommerce/