Just to backup what Lynford has said (i'm trying to help him sort this whole mess out) the board is pretty busy, its got about 1500 memeber (i'd guess 500+ are regulars eeither posting or just browsing) and is pretty busy, shifting 30/40/50GB of traffic a month. I've no idea how big the access database is (still havent got ftp access back from purplenames) but i'm sure its a biggun!
Whilst the members have a whip-round to raise the cash to upgrade to a MS SQL database we're planning on making a few changes to the board to try and solve the problems in the short term just to shut up the hosting company, can someone advise if they will be any good to help the performance:
Here's what we plan
- limit to 20 topics displayed per page
- Only display 10 posts per page when viewing a topic
- Disable search faciitly (if possible)
- Remove some of the threads that have 1000/2000/3000+ posts in them
All in an effort to try and speed things up and reduce load on the server when opening any page by limiting the content that needs to be accessed at any time.
Can anyone recommend anything else or advise if any of these things will be pointless.
Many thanks
Alex