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! any ideias? 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
Yep, im using the virtual path to connect to the virtual base im using the calendar, photogalley and conquerorchat MOD!
------------- Do your best - GOD will do the rest |
dpyers wrote: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...
thanks you all for your help!! :-) i really appreciated! ------------- Do your best - GOD will do the rest |