Alright, so I have 324 blogs on a single WordPress Multisite installation that we started almost two months ago. Bluehost just contacted me saying that we're close (2,900) to maxing out the number of database tables (3,000) we can use account-wide. We do have a premium account.
First question: is that number of tables unexpectedly high for the number of blogs we have? Could something be squatting on tables unnecessarily?
Second question: is there a way to significantly consolidate or otherwise reduce that number of tables down to a number that will allow us to continue to grow? How much time might we have before *needing* to switch to a dedicated server? I know that's a ridiculous question to have to ask; we should just do it, but I don't make the decisions.
Other information: Despite having so many blogs, we don't have tons of traffic. These blogs are often set up and then left to stagnate.
Any other suggestions/ideas?
Any help would be appreciated. Thanks!