Ecommerce Shopify WordPress Discussion

Large WordPress E-Com Site – Very slow performance (High volume of Post Meta data and Order Data) [closed]

Closed. This question is not about programming or software development. It is not currently accepting answers. This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to explain where the question may be able to be answered. Closed yesterday. Improve this question I have an e-com store running on WordPress (Together with using WooCommerce) - We've operated the site for around 4 years now, and in that time, our website has grown heavily in sales and customer signups which is great, although, the downfall, is that our website has become extremely slow in many areas (This includes executing tasks such as, editing products from the backend of the store, and from the perspective of how our customers navigate through our website and complete their orders. I think the challenge here, is that over time, a great amount of postmeta data and usermeta data has been building up in the MySQL database, and in result, it's caused a real downfall in performance, in which is causing multiple issues across our site with regards to loading times. To be exact: Our postmeta database table is made up of ~3,554,802 rows Our usermeta database table is made up of ~2,759,005 rows Finally, woocommerce_order_itemmeta is made up of ~1,343,448 rows Many of the other tables we have present in our db are generally within the six figures region, in terms of row count. Whilst I know we could go ahead and delete old data (e.g. Old order data etc), could anyone recommend an alternative approach to resolving the performance issue, without deleting data? I've seen articles which have advised to use an indexing plugin, for indexing the db tables where the row count is high, however, the last time we tried this approach, our database corrupted (But we had a backup on standby ready to restore) I know there is a lot of posts/articles out there in regards to WordPress bloating, which comes with large amounts of metadata and postdata being built up within the db, but is there any recommendations e.g. Alternative db engines/systems which are more suited for processing larger quantities of data? Or perhaps any recommendations based around performing optimisations to our current db for the faster processing of db tables with large row counts? (As a way of speeding up page load time) MySQL DB Server Specification: We are currently running our DB on a remote database server and we are using MySQL 8.0. Server Specification: Bare Metal Server CPU:16 Core x 3.0 GHz (AMD Epyc 7302P) RAM:128 GB NVMe2 x 960 GB Hardware RAID 1
TurboCommerce make the better internet purchasing globaly

Turbo Multi-language Translator

Make the better internet purchasing globaly

Turbosify SEO Speed Booster

5.0 (7) Free plan available
Get better conversions by improving store loading speed Installed

Turbo Multi-language Chat - AI Customer service in one hand

TurboCommerce make the better internet purchasing globaly
Our products

The help you need, when you need it

App by Turbo Engine

3 apps • 5.0 average rating

Turbosify Speed Booster

5.0 (7)
Get better conversions by optimizing shopify store Google page speed Installed

Turbosify Translator for Wordpress Woocommerce

5.0 (74) Free Wordpress Woocommerce Plugin
Translate your wordpress website to multiple language within 1 click, no configuration needed, no No technical required

Grow your business here

Whether you want to sell products down the street or around the world, we have all the tools you need.