Hey guys, I’ve run into issues with some wordpress, single-site (not multi-site) databases getting rather large in the past, and leaving me with web hosts complaining about “slow queries” in MySQL.
I’m wondering if the MultiDB plugin is maybe the answer to this. Anyone else run into this issue? At this point, it's becoming a pain in my arse, and I'm willing to consider anything other than crazy expensive hardware or cloud upgrades...mainly because I've not been able to monetize the sites to their full potential yet.
In fact, they're large Wordpress sites that don't get a crazy amount of traffic. So the size is the issue, rather than the need for scaling due to traffic or amount of queries. I welcome all replies, as I'm somewhat lost on this one.