| Author |
 Topic Search  Topic Options
|
simon121 
Groupie
Joined: 28 December 2004
Location: Israel
Status: Offline
Points: 49
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: forum get’s slow when a lot users logged
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?  |
|
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
simon121
Groupie
Joined: 28 December 2004
Location: Israel
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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:-
- 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 I
wouldn't use an Access database for a forum backend unless you only had
a 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
|
|
|
|
xeerex
Senior Member
Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601
|
Post Options
Thanks(0)
Quote Reply
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 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:
- 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 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.
wrote:
Access is a flat file database system |
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).
|
|
|
|
simon121
Groupie
Joined: 28 December 2004
Location: Israel
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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)
|
|
