Web Wiz Support and Community Forums : forum get’s slow when a lot users logged

Web Wiz Support and Community Forums : forum get’s slow when a lot users logged https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 22:40:37 +0000 Tue, 03 May 2005 15:29:40 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=14916 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[forum get’s slow when a lot users logged : Please read my posts i posted...]]> https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82387.html#82387 Author: dj air
Subject: 14916
Posted: 03 May 2005 at 3:29pm

Please read my posts i posted yerterday on moving from Access to SQL. i had performed one the other day on a clienbts Database..

it only had 18,000 posts but stuill..

the best way i found is mentioned there.. i used Access 2003 (i think a bug was fixed from Access XP to access 2003)
]]> Tue, 03 May 2005 15:29:40 +0000 https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82387.html#82387 <![CDATA[forum get’s slow when a lot users logged : i wish i could move to sql but...]]> https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82384.html#82384 Author: simon121
Subject: 14916
Posted: 03 May 2005 at 1:31pm

i wish i could move to sql but i dont know how and i tryed the step by step guide u have but didnt succeed

always when i try to connect the sql on the server using the enterprise managet it tells me that the DB not found

]]> Tue, 03 May 2005 13:31:41 +0000 https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82384.html#82384 <![CDATA[forum get’s slow when a lot users logged : wrote: 2900 members, 63000...]]> https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82365.html#82365 Author: xeerex
Subject: 14916
Posted: 03 May 2005 at 10:38am

wrote:

2900 members, 63000 posts, 8764 topics

the Database size is 70 MB

Holy crap Batman! That is impressive and speaks well of -borg-'s code!

First, I agree with -borg- that you should move to SQL Server. It isfar more robust and scalable, and it was designed for high trafficserver-client environments.

However, if that is not an option I would start by doing the following:

Clean up your forums by removing old/outdated/nonuseful posts. (Download a backup archive of the database first)
Close your forums, download the database, compact/repair through Access, reupload the database, open your forums.
Turn off the active users, etc, on your forum home page
Keep a good schedule of maintaining your database in this manner.

Disclaimer:

I run an Access powered forum with ~16k members, peaks of 80-150 activeusers (up to 6 hours at times), ~5k posts, and an uptime of 453 days(except a few server restarts).

Current database size: 15.61MB

I have purged members 3-4 times removing 4-5k members each time and follow the suggestions I posted above.

wrote:

Access is a flat file database system

Technically a "flat file database" is non relational and uses a singletable to store its information such a CSV files, etc. Access iscertainly a relational database, but its engine was not designed toscale in a server environment to the extent that SQL Server does (whichis very robust).
]]> Tue, 03 May 2005 10:38:49 +0000 https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82365.html#82365 <![CDATA[forum get’s slow when a lot users logged : WOW!!! I'm surprised...]]> https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82361.html#82361 Author: WebWiz-Bruce
Subject: 14916
Posted: 03 May 2005 at 9:23am

WOW!!!

I'm surprised Access is still going.

MS Access was never designed as a web site backend database system,especially for something that uses as many database resources as a forum.

Access was designed as a desktop database system to store small amountsof data in that would only be accessed by a handful of users.

Access is a flat file database system and has allot of limitations including:-

Often becomes corrupted
Only has a pool of 20 connections per web server, split between all sites
Size limitations
The entire database needs to be loaded into the web severs memory each time the database is connected

These are just a few of the limitations, and in my personal opinion Iwouldn't use an Access database for a forum backend unless you only hada handful of users a day

You should look into moving to MS SQL Server as soon as possible as it doesn't have the limitations that Access has.

Edited by -boRg- - 03 May 2005 at 9:24am]]> Tue, 03 May 2005 09:23:40 +0000 https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82361.html#82361 <![CDATA[forum get’s slow when a lot users logged : im using v7.5 access 2900 members,...]]> https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82352.html#82352 Author: simon121
Subject: 14916
Posted: 03 May 2005 at 7:26am

im using v7.5 access

2900 members, 63000 posts, 8764 topics

the Database size is 70 MB

how i can fix it? help me plz

]]> Tue, 03 May 2005 07:26:38 +0000 https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82352.html#82352 <![CDATA[forum get’s slow when a lot users logged : what version are you using? if...]]> https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82310.html#82310 Author: dj air
Subject: 14916
Posted: 02 May 2005 at 6:39pm

what version are you using?

if Access it maybe that, but also what size is th eforum, how many members, posts, topics etc.

also it can depend on your host and the load of the servers.

i see you have 63,000 posts.

are you running MSSQL version if not i would recommend moving to it.
]]> Mon, 02 May 2005 18:39:02 +0000 https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82310.html#82310 <![CDATA[forum get’s slow when a lot users logged : i dont know why it happens and...]]> https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82281.html#82281 Author: simon121
Subject: 14916
Posted: 02 May 2005 at 8:36am

i dont know why it happens

and its not a problem n the server

when there is 15-20 active users on my forum he gets very slow

why why?

]]> Mon, 02 May 2005 08:36:14 +0000 https://forums.webwiz.net/forum-gets-slow-when-a-lot-users-logged_topic14916_post82281.html#82281