Fix your data architecture for analytics, not your server
Slow reporting on WooCommerce is usually a schema problem, not a hardware problem. This covers custom analytical tables, the Inmon and Kimball warehouse schools, lakehouses, and where event-driven architecture fits a WordPress stack.