We had to change our webhost due to increasing costs with our current one.
During a resource audit of your account, I'm afraid we've discovered an issue that must be addressed.
In reviewing the account, we noticed you have in excess of 250,000 posts. This means that your community has achieved great success for which we are extremely pleased. Unfortunately, this also means the resources required to power your community have grown significantly. The database architecture (mysql) for example, causes the posts table to "lock" during searches. This means, while performing a search, any requests to view a topic, post to a topic, etc. are "locked" and backlogged until the search completes. This causes all of the connections at that time to be held open, leaving less available resources to other clients. As the size of your posts table (number of posts) increases, the performance impact becomes more far reaching. This is fixed by installing an indexing engine known as Sphinx. In a shared environment, it is not feasible to provide this on anything less than our advanced packages.
Most hosting providers have some wiggle room for more intense clients as a number of other clients may only be using a small fraction of their allocated resources because their sites are active. Because 100% of our clients are running dynamic communities, we do not have the luxury of playing that numbers game and thus, we do not oversell.
In order to accommodate a forum that is the size yours has grown to, we would have to upgrade you to the Ultra 100 package, which cost is $69.99 per month. We realize that that's a significant price increase, but unfortunately there are no other options that we are able to offer. With an Ultra 100 package, we would be able to install the Sphinx Search engine, and that would drop server load significantly as well as improve search speeds for your users.
As much as we hate to turn a hosting client away, we also don't want to charge you unnecessarily.
It's more than the post count driving this issue, it's the user average count as well.
It's at 73 average users right now, and that's one of the things which requires the package upgrade to Ultra 100.
So, refuse to pay $69.99 a MONTH, so we were forced to move elsewhere. So here we are, we are up and running again with our new host company.
Sheila, Jillie and Bee