So I have a really large woocommerce site (partsboss.co) that has around 83,000 items. It's on VPS hosting with digitalocean, and things were running super fast until around 50,000 items. Now the site is just draaaaaaaaaging.
It's set up on Ubuntu with nginx, APC and Varnish caching. I'm not really sure where the bottle neck is or how to fix it, but as far as I can tell it's basically taking forever to query the mysql database and return results.
So my question is, do I need to just optimize mysql more (if so, how? Not really a mysql expert) or do I need to split the database with something like Hyperdb? Again, if that's the case, I read the readme for Hyperdb and it wasn't too explicit... if you know of any good tutorials, throw them my way :) Any help would be much appreciated, thanks!