'Pruning Woocommerce orders
I have a very large site with 60k orders, most are subscriptions. 11k subscriptions over 6-7 years, but only 600 are active. This weight paired with an LMS makes the site very slow and hard to manage.
Are there any best practices around pruning or purging older orders for inactive subscriptions in an effort to improve database speed?
Misc config notes: DigitalOcean with 32gb ram, DigitalOcean Database cluster with 2gb ram dedicated to the DB. DB site uncompressed is around 2gb.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|