| Author |
 Topic Search  Topic Options
|
Gargaleo 
Newbie
Joined: 01 June 2004
Status: Offline
Points: 20
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: very slow forum!!!!!
Posted: 06 July 2004 at 1:50pm |
http://www.comunidadedoredentor.com.br/forum
Guys i need help! I use acess version and the DB is in 8 MB only!
What's wrong with it? why is it so slow??
i migrated from another server and the new server is very slow..
any ideias?
maybe using another iis version or anything similar is making it so slow?
thanks in advanced!
|
 |
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 July 2004 at 1:54pm |
|
Try doing a compact and repair, that should shrink down the db size thus increasing performance. Also consider upgrading to the MSSQL version...
|
|
zaboss
Senior Member
Joined: 20 August 2002
Location: Romania
Status: Offline
Points: 454
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 July 2004 at 1:56pm |
|
Indeed, 8MB is already much
for Access, although I have use it until 20 MB, but on not very visited site (maximum 200 visits per day).
|
|
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 July 2004 at 2:29pm |
|
Access is designed for heavy loads... i.e. lots of updates, deletes inserts etc. SQL server on the other hand is a lot more suited to bigger sites
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 July 2004 at 3:32pm |
The site is slow. The forum part of it is incredibly slow (gave up after 5 min). I'd start looking at the method being used to connect to the DB. Perhaps try an alternative method. Also, check if you have any mods or other code accessing the db that may be putting a lock on it.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 July 2004 at 4:05pm |
|
It's not 5 minutes slow, it wakes about 20 seconds for me. The main site appears normal to me.
|
|
Gargaleo
Newbie
Joined: 01 June 2004
Status: Offline
Points: 20
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 July 2004 at 5:59pm |
 dpyers wrote:
The site is slow. The forum part of it is incredibly slow (gave up after 5 min). I'd start looking at the method being used to connect to the DB. Perhaps try an alternative method. Also, check if you have any mods or other code accessing the db that may be putting a lock on it.
|
Yep, im using the virtual path to connect to the virtual base
i try to connect trought the pshysical path (//server/windows/domain/blablalba), but no better results
im using the calendar, photogalley and conquerorchat MOD!
This is what probally is holding me back!!
|
|
steve
Groupie
Joined: 26 June 2002
Location: United States
Status: Offline
Points: 126
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 July 2004 at 7:03pm |
I believe he means the connection driver itself. Change that in the common.asp files. There are a few other choices commented out. Try the one for Access 2002...will probably help. Most definitely make sure your access db is compacted and repaired first. The access version should last well beyond 8mb even with a fairly steady stream of traffic. In fact, I've seen it run past 30 mb, no problem with a steady user base of 15-30 at a time.
Update: I see you are using a few mods. Perhaps try removing them to see if it helps. Try to figure out what is causing the slowdown.
Edited by steve
|
|
