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

  New Posts New Posts RSS Feed - Forum speed and performance
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum speed and performance

 Post Reply Post Reply
Author
Imperator View Drop Down
Newbie
Newbie


Joined: 02 October 2004
Status: Offline
Points: 39
Post Options Post Options   Thanks (0) Thanks(0)   Quote Imperator Quote  Post ReplyReply Direct Link To This Post Topic: Forum speed and performance
    Posted: 19 October 2005 at 2:38am
My forum seems to be getting slower by .1 second every two to three months. It averages about 2.3 seconds on the index now. I was wondering what can be done to increase the speed other than deleting posts or moving out of MS Access.

Would it help if I reduce the number of forums on the index or reduce the number of "lone" moderators?

255 MB database, 110k posts
MS Access
31 forum sections
About 45 mod assignments on the forum


Edited by -boRg- - 19 October 2005 at 12:42pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 19 October 2005 at 4:36am
That is one big Access database!!

The problem with Access is that it is a flat file database system designed for desktop use and not up to the task of a big forum.

Each time someone connects to your forum the entire 255Mb file needs to be loaded into memory, which takes time.

MS SQL Server dosn't work in this way and can handle many 1,000's of connections at once and can be many gigs in size.

The other problem with Access is that it often becomes corrupted and unrecoverable.

I would recommend that you change to SQL Server as soon as you can.
Back to Top
Imperator View Drop Down
Newbie
Newbie


Joined: 02 October 2004
Status: Offline
Points: 39
Post Options Post Options   Thanks (0) Thanks(0)   Quote Imperator Quote  Post ReplyReply Direct Link To This Post Posted: 19 October 2005 at 11:25am
I realize access isn't the ideal database, but what I also see is that my forum sub-indexes, even the biggest (15k posts), still generates the page in 0.4 seconds compared to 2.3 seconds on the main page. 0.4 seconds is very comparable to the sections on this forum, which I assume runs on SQL. So doesn't this imply that there're ways I can speed up the index by removing content and/or forum section?. For example, It looks like if I replace the forum index with a completely static page, it would essentially fix all the speed problems. (obviously a static page isn't so great, but some of the features like post count and "code generated" moderator checking I can definately cut out and still suffice)


Back to Top
Imperator View Drop Down
Newbie
Newbie


Joined: 02 October 2004
Status: Offline
Points: 39
Post Options Post Options   Thanks (0) Thanks(0)   Quote Imperator Quote  Post ReplyReply Direct Link To This Post Posted: 19 October 2005 at 8:55pm
Yeah, I definately would've gone to SQL, but hosts that are cheap are hard to find. Even at their premium plan, Jodohost doesn't not have the bandwidth I need for my site + forum. Currently, I'm in brinksters which I'm fairly satisfied. They give 75GB bandwidth for $8/month, which is pretty good. It has no SQL database but so far the forum is still running. I guess there hasn't been any scientific tests on how big the Access DB can get before it fails, so I'll report back when the forum does fail due to overextension.
Wink

Thanks for replying to my inquiry!


Back to Top
 Post Reply Post Reply

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.