https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 15 Apr 2026 22:52:55 +0000 Wed, 19 Oct 2005 20:55:15 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=16950 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/forum-speed-and-performance_topic16950_post92413.html#92413 Author: Imperator
Subject: 16950
Posted: 19 October 2005 at 8:55pm

Yeah, I definately would've gone to SQL, but hosts that are cheap arehard to find. Even at their premium plan, Jodohost doesn't not have thebandwidth I need for my site + forum. Currently, I'm in brinksterswhich 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 isstill running. I guess there hasn't been any scientific tests on howbig the Access DB can get before it fails, so I'll report back when theforum does fail due to overextension.


Thanks for replying to my inquiry!


]]> Wed, 19 Oct 2005 20:55:15 +0000 https://forums.webwiz.net/forum-speed-and-performance_topic16950_post92413.html#92413 https://forums.webwiz.net/forum-speed-and-performance_topic16950_post92390.html#92390 Author: Imperator
Subject: 16950
Posted: 19 October 2005 at 11:25am

I realize access isn't the ideal database, but what I also see is thatmy forum sub-indexes, even the biggest (15k posts), still generates thepage in 0.4 seconds compared to 2.3 seconds on the main page. 0.4seconds is very comparable to the sections on this forum, which Iassume runs on SQL. So doesn't this imply that there're ways I canspeed up the index by removing content and/or forum section?. Forexample, It looks like if I replace the forum index with a completelystatic page, it would essentially fix all the speed problems.(obviously a static page isn't so great, but some of the features likepost count and "code generated" moderator checking I can definately cutout and still suffice)


]]> Wed, 19 Oct 2005 11:25:20 +0000 https://forums.webwiz.net/forum-speed-and-performance_topic16950_post92390.html#92390 https://forums.webwiz.net/forum-speed-and-performance_topic16950_post92381.html#92381 Author: WebWiz-Bruce
Subject: 16950
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 systemdesigned 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.
]]> Wed, 19 Oct 2005 04:36:12 +0000 https://forums.webwiz.net/forum-speed-and-performance_topic16950_post92381.html#92381 https://forums.webwiz.net/forum-speed-and-performance_topic16950_post92376.html#92376 Author: Imperator
Subject: 16950
Posted: 19 October 2005 at 2:38am

My forum seems to be getting slower by .1 second every two to threemonths. It averages about 2.3 seconds on the index now. I was wonderingwhat can be done to increase the speed other than deleting posts ormoving 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]]> Wed, 19 Oct 2005 02:38:55 +0000 https://forums.webwiz.net/forum-speed-and-performance_topic16950_post92376.html#92376