Heavy load for the Web Wiz Forums
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=11240
Printed Date: 09 April 2026 at 6:43am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Heavy load for the Web Wiz Forums
Posted By: dboy
Subject: Heavy load for the Web Wiz Forums
Date Posted: 20 July 2004 at 4:50am
|
Dear All, I start with access version and now upgrade to MS SQL Version ( Forum version 7.5 ) running on Win2003 share server here are Server Spec Intel SE7501WV2SCSI
RAID-5 HDD Maxtor Ultra320
RAM Kingston 1GB
Dual Xeon 2.4GHz
Average CPU Utilization 7%
here are lastest statistic
and here are SQL stat
Everything run fine. but when user grow up more and more the forum slow down and I get often of this error Microsoft OLE DB Provider for SQL Server error '80004005' /forum/default.asp, line 374 and some time get Microsoft OLE DB Provider for SQL Server error '80040e31' The error show and some of topic missing on the page if reload or refresh some time error didn't show and work properly.
Anyone have same my stituation ? How I can solve ? Only 80-90 users at the same time , is it too large? What is maximum load or user which forum can handle?
I try to seach similar problem and didn't get solution for heavy forum site.
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 20 July 2004 at 6:07am
|
The first error is genreally a network or SQL server problem, could be
the sl server is rebooting, or a network failer to connect to the sql
server. Web wiz forums has been known to handle over 200,000 posts without any issues. You should consider cutting the number of forums you have as 56 is allot and each forum means an extra 3 to 4 more calls to the database on the main forum page (default.asp). That means 200+ database calls to load up your main forum homepage. ------------- 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: dboy
Date Posted: 20 July 2004 at 11:46pm
|
Thank -boRg-,
|
Posted By: psycotik
Date Posted: 21 July 2004 at 7:34am
| You could also change your sql logging to "simple", otherwise it saves all transactions. That will probably reduce your log size to about 20-30mb and as the server doesnt have to log everything, might increase performance a bit. |
Posted By: dimoss
Date Posted: 11 February 2005 at 2:49am
How can I change the sql logging to "simple"???? I have problem because my host has a limit of 15mb for the transaction logs so I have to backup every two days!!! (.and I hate that) I think this is the solution but how can I do this? Thanks. |
psycotik wrote:Posted By: dj air
Date Posted: 11 February 2005 at 6:14am
|
who is your host? ussually you have to conact them, to do so. just ask them to set the database to simple. |
Posted By: zadax
Date Posted: 11 February 2005 at 6:35am
I HAVE THE SAME EXECT PROBLEM !!!! I POST THE QUESTION SOME DAYS AGO BUT NONE GIVE ME RIGHT ANSWER
whan i get over 40+ users on i get ur Errors to
it make me and the users crazy Defult page work sooooo slow
and i got like 30 forums and 7000 members
i need help to ... i dont know how to do the Defult page "static" like u said becoz it work with lot mods and stuff i have no idea how to do it
can somone help ?
|
Posted By: WebWiz-Bruce
Date Posted: 11 February 2005 at 7:10am
|
THe SQL Server error is a problem with your SQL Server, I came across
this problem recently and it was solved by putting more RAM in the
server with the MS SQL 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: zadax
Date Posted: 12 February 2005 at 10:43pm
|
BORG we got 2gb Ram on the Server and the Server is Really fast and like 6 sites on this Sql Server and they work Fine
mine give the errors only whan 40+ members online
and more on more Defult Page Super Slow ...
|
Posted By: WebWiz-Bruce
Date Posted: 13 February 2005 at 4:48am
|
Do you have the recovery model set to simple so that less actions are logged? If not, then do so as you will probally find a performance boost. ------------- 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: ljamal
Date Posted: 13 February 2005 at 9:07am
|
Taking time to re-write and optimize the default.asp page for SQL will provide you with a boost. Most likely it's the default.asp page and the search that is causing the problem as one has multiple server calls and the other is just a hugwe query ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: zadax
Date Posted: 13 February 2005 at 8:37pm
|
" recovery model set "
help
 |
Posted By: zadax
Date Posted: 16 February 2005 at 9:16am
| up |
Posted By: dj air
Date Posted: 16 February 2005 at 9:55am
| just ask your host to turn that to simple .. it will then run at better performace. |