Question: What are my options for archiving threads? All I can think of is to manually create a separate table and move threads there via SQL commands. I've tried searching on stuff related to archiving, and the best I've come up with is people agreeing that it'd be a good idea!
But no proven method of actually how to accomplish it!?
Background: I've recently had my site blocked because, according to the host, the site was overloading their (shared) server due to SQL queries taking too long to execute. We're not a super-busy site, the average users concurrently hitting the forums would be around 10-20!? So news that we're overloading came as a surprise to me.
They claim that reducing the size of the database will reduce the execution time of queries. Our total database size is around the 130 MB mark, which I don't consider to be that large and so I really don't feel like archiving. But if push came to shove, I need to consider a way of reducing the size of the Posts table. Any ideas would be appreciated.
Other stuff: This isn't the first time we had our host pull the plug on us, so I'm considering switching providers. We're on a shared host, because the pricing suits us (we're a non-commercial video game fan site). Without having any kind of feedback or metrics available, I find that I'm totally in the dark when it comes to finding the right host for us. Apart from physical disk space requirements, I have no idea what kind of resources I require of a host. Is there a way for me to determine this?
Another option is to remain with the current host, but switch to a dedicated server, but this costs more and so is undesirable.
UBB.t version: 6.5.x
Site URL: http://virtuafighter.com (currently down at the time of posting!)
