Print Page | Close Window

very slow forum!!!!!

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11104
Printed Date: 30 March 2026 at 8:55am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: very slow forum!!!!!
Posted By: Gargaleo
Subject: very slow forum!!!!!
Date Posted: 06 July 2004 at 1:50pm

http://www.comunidadedoredentor.com.br/forum - 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!



-------------
Do your best - GOD will do the rest



Replies:
Posted By: Mart
Date 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...


Posted By: zaboss
Date 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).


-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web


Posted By: Mart
Date 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


Posted By: dpyers
Date 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.


Posted By: Mart
Date 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.


Posted By: Gargaleo
Date Posted: 06 July 2004 at 5:59pm
Originally posted by dpyers 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!!


 



-------------
Do your best - GOD will do the rest


Posted By: steve
Date 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.



Posted By: dpyers
Date Posted: 06 July 2004 at 10:21pm

Just went back there, and the site seems normal now. As Steve noted, I was thinking about different drivers rather than different paths in the connection string - odbc instead of dsn-less, , the 2002 driver, etc.

In addition to checking the mods, you might want to ensure that your web host is running at least MDAC 2.6.

 



-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: WebWiz-Bruce
Date Posted: 07 July 2004 at 5:03am
If it's running slow at times then this is due more to an overloaded server as the server runs low on resources your forum will run slower and slower till it times out.

Try changing host or opting for a better hosting plan on a less populated server.


-------------
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: Gargaleo
Date Posted: 11 July 2004 at 6:26pm

Well guys, i just installed a /forum2 with basic features and original Database and the speed is about the same...
So, its the server that is holding the perfomance back really....

 

thanks you all for your help!! :-) i really appreciated!

[]'s



-------------
Do your best - GOD will do the rest



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net