Server resourse issue with large forum

[SteveC]

I have a site that has a small number of users but has been around for several years so we have a lot of posts. Here are the stats

Threads: 32,607, Posts: 547,854, Members: 2,235, Active Members: 201

I'm currently hosted by Rochen. About a week ago, my forum started getting really slow at certain times of the day. They tell me it's because I have too many posts and when someone does a search by clicking on "new posts" it overwhelms the server. Here are the specifics of what they are saying:

the server is actually being overwhelmed, you queries are consuming 10-20X the resources (Disk I/O) permitted at any given time on a shared plan by our AUP (2% of overall system resources over a 24 hour period). Your scripts are performing full table scans or joins that are too large to fit in memory, and the result is a significant amount of disk I/O.

They've given me 48 hours to prune 75% of my posts, which I don't want to do because I don't want to lose them or move to another host.

Is there anything I can do to reduce the server load? Can posts be archived so they aren't part of a search query? Or is there a way to make searches only look at the last month or so of posts unless a user specifies otherwise?

Or do I need to move to a dedicated server? If so, any suggestions of who to go with?

thanks!

[Max Taxable]

The host is blowing smoke up your rear end. Get yourself another one.

[SteveC]

Originally Posted by Max Taxable

The host is blowing smoke up your rear end. Get yourself another one.

Thank you, Max. That's what I suspected. We've had no problems for years and it's not like traffic suddenly doubled. Would you be able to suggest anyone for me to move to? I'm really jammed with work right now and need to get this resolved quickly and simply.

[snakes1100]

Many hosts pull this crap with forum based vb sites, you would be better to find a private host or get a vps.

[Max Taxable]

Originally Posted by SteveC

Thank you, Max. That's what I suspected. We've had no problems for years and it's not like traffic suddenly doubled. Would you be able to suggest anyone for me to move to? I'm really jammed with work right now and need to get this resolved quickly and simply.

Oddly enough I have had very good service with GoDaddy for many years. I have been getting it via a reseller, http://www.domainspricedright.com

Never one issue and my board is comparable to yours in size and history.

[snakes1100]

If its a reseller from a customer of godaddy, thats a bit different than using on of godaddys vhosting accounts, which godaddy does the same thing to vb forums.

[Max Taxable]

Originally Posted by snakes1100

If its a reseller from a customer of godaddy, thats a bit different than using on of godaddys vhosting accounts, which godaddy does the same thing to vb forums.

I have never had one problem at all, and the customer support people have been great. Been using this hosting for several sites and forums since 2004.

It's godaddy product and customer service, the reseller is just a friend who makes a tiny stipend and has nothing at all to do with the product or service. Not sure what "vhosting" is, but I have what they call the "Shared Deluxe." It's unlimited bandwidth, sites and storage, $60 annually.

[SteveC]

FYI, I currently have a level 2 business acct with Rochen. Do I need something a lot more robust?

http://www.rochenhost.com/business-hosting

[Max Taxable]

Originally Posted by SteveC

FYI, I currently have a level 2 business acct with Rochen. Do I need something a lot more robust?

http://www.rochenhost.com/business-hosting

You are paying $155.40 annually for far, far less than I am getting for $60. Go to the link I gave you and check it out.

[SteveC]

hey sorry Max but that turned out to be a nightmare. I talked to a salesperson on the phone, gave him all my specs (# of posts, databse size, users etc) and he assured me everything would be fine. Signed up for a 3 year plan and tried to import my VB database. Nothing seemed to be happening so I called tech support. The support person told me the maximum file size I could import is 8mg. My database is 800mg. He told me I could "break it down" but he couldn't tell me how to do it. I really need help here. Can anyone steer me to a reliable host where I can import this database and get my site up and running again?