I have a server VPS 4vcore cpu, 16GB ram, 40GB SSD
I have a woocommerce with ~ 4000 products and ~150 attributes (also use woof attribute filter).
When I try to reach pages that queries products (with attributes i think) the pages takes too long to load (6-15+ seconds) if i try to load admin orders list it loads fast.
wp_posts has 24.000 rows, wp_postmeta has ~500.000 rows
What I can do to improve? (will upgrade to 8vcores cpu, 32GB ram, 80GB ssd) but dont know if it will help alot.
images from statistics