Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - My forum has been removed by............
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

My forum has been removed by............

 Post Reply Post Reply Page  <123>
Author
Restricted View View Drop Down
Newbie
Newbie


Joined: 09 May 2005
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote Restricted View Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2005 at 7:15am
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
 
 
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2005 at 7:21am
with the finugures mentioned there it will be hard to reduce it to a satifcatuary figure.

MSSQL is the only option i would say.

because with what you are saying you would need to empty very regular.

also the search engine is not disable able unless yopu code it yourself. but that wont do that much really .. as its as a whole to big.
Back to Top
Restricted View View Drop Down
Newbie
Newbie


Joined: 09 May 2005
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote Restricted View Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2005 at 7:31am
Originally posted by dj air dj air wrote:

with the finugures mentioned there it will be hard to reduce it to a satifcatuary figure.

MSSQL is the only option i would say.

because with what you are saying you would need to empty very regular.

also the search engine is not disable able unless yopu code it yourself. but that wont do that much really .. as its as a whole to big.
 
Thanks,
 
we're aware that we need to move over to ms sql, but these will only be a stopgap measure in desparation to get the hosting company off our backs in the meantime, hope to upgrade asap!
 
We just find it stange that the hosting company have only justed picked up on this when the forum has been running in its current state for about a ywear now. Oh well....Confused
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2005 at 7:35am
it might be that fasthosts have just started getting onto them.

but they should really have asked him to sort the problem within x days else it will be suspended.


in desperation...lol.. i would also do a Compact & Repair on the database. when there is access to it.
Back to Top
Restricted View View Drop Down
Newbie
Newbie


Joined: 09 May 2005
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote Restricted View Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2005 at 7:53am
Just got ftp access the access database is 220MB!
I assume that i can just open it up using access on my pc, run the compression wizard and then upload it to the webserver again and it will run without any problems?
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2005 at 8:51am
as long as you close the forum first then download, use Compact and repair and re uplaod.

you ca ntry the one in the admin area but people seem to have problems with it.

i had to read that twice 220 meg. thats why they don't want it on the server. a couple people on the site and thats half a gig of ram taken. as Access is a flat file. and has to load all of it
Back to Top
xeerex View Drop Down
Senior Member
Senior Member


Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601
Post Options Post Options   Thanks (0) Thanks(0)   Quote xeerex Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2005 at 9:01am
220MB is crazy for an Access forum. Not only do you need to c/r it, but you also need to spend some time removing topics and deleting old members.
Back to Top
Restricted View View Drop Down
Newbie
Newbie


Joined: 09 May 2005
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote Restricted View Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2005 at 1:57pm
Originally posted by xeerex xeerex wrote:

220MB is crazy for an Access forum. Not only do you need to c/r it, but you also need to spend some time removing topics and deleting old members.


You're quite right!

Did did a compress/repair today and got the database bown to 90MB, we're going to delete moast of the old posts and some expired users tomorrow so hopefully the database will be brought down to <30MB which will have to do for a few weeks until we can get the system using MS SQL instead.

Thanks to everyone for their advice and help Clap
Back to Top
 Post Reply Post Reply Page  <123>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.