Forum speed and performance
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16950
Printed Date: 16 April 2026 at 2:22am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Forum speed and performance
Posted By: Imperator
Subject: Forum speed and performance
Date 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 |
Replies:
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Imperator
Date 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) |
Posted By: Imperator
Date 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.  Thanks for replying to my inquiry! |