forum get’s slow when a lot users logged
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=14916
Printed Date: 12 April 2026 at 10:36pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: forum get’s slow when a lot users logged
Posted By: simon121
Subject: forum get’s slow when a lot users logged
Date 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?  ------------- http://pakapaka.info/forum"> 
|
Replies:
Posted By: dj air
Date 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. |
Posted By: simon121
Date 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 ------------- http://pakapaka.info/forum">
|
Posted By: WebWiz-Bruce
Date 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 amounts of 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:-
You should look into moving to MS SQL Server as soon as possible as it doesn't have the limitations that Access has. ------------- 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: xeerex
Date Posted: 03 May 2005 at 10:38am
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 is far more robust and scalable, and it was designed for high traffic server-client environments. However, if that is not an option I would start by doing the following:
I run an Access powered forum with ~16k members, peaks of 80-150 active users (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.
Technically a "flat file database" is non relational and uses a single table to store its information such a CSV files, etc. Access is certainly a relational database, but its engine was not designed to scale in a server environment to the extent that SQL Server does (which is very robust). ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
wrote:Posted By: simon121
Date 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 ------------- http://pakapaka.info/forum">
|
Posted By: dj air
Date 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) |