Print Page | Close Window

Is WebWizForums Scalable

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=22463
Printed Date: 08 April 2026 at 6:34am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Is WebWizForums Scalable
Posted By: cyberax
Subject: Is WebWizForums Scalable
Date Posted: 20 January 2007 at 7:36pm
Hi Borg,

What you think how much traffic the current WebWizForum 8.05 software can take?
 
And can it work in high traffic scenerios something over 1 million pages views a day
 
Regards,
 



Replies:
Posted By: WebWiz-Bruce
Date Posted: 21 January 2007 at 6:17pm
That shouldn't be a problem, the following forum link usually has between 100 and 200 active users online at any given time:-

http://www.lotrplaza.com/forum/ - http://www.lotrplaza.com/forum/

Other people have reported installations of Web Wiz Forums with over 1 million posts.

However, you would need to use the SQL Server version to handle this amount of traffic.

The SQL has been performance tuned and the number of database hits have been kept to a minimum, with so called 'dirty reads' and only locking rows during updates.

To add to this common database queries that do not change often and other data is cached in the web servers memory to reduce the number of hits on the database. However this does not mean the server requires an extra memory than most normal ASP database driven web site to run.


-------------
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: Melkor
Date Posted: 22 January 2007 at 3:58am
Hey! I know that site! Hehe!

As a user of WWF and Tech Admin of the site mentioned by Borg above I can say without hesitation that WWF is easily capable of handling 1 million hits a day and more.

lotrplaza.com has been using WWF since we began in January 2002 and the version we used for the first 5 years (which had to be one of the first WWF's released I think) handled traffic in excess of that figure on a regular basis. The only issues we ever had with relation to traffic were all server based. That first early version of WWF worked like clockwork right up until December of last year when we switched to V8.5.

We average 2 million posts a year from 80,000 members and easily managed 200,000+ page views a day.

You won't have a problem with WWF as long as you have a server capable of handling that type of visitor load.


Posted By: jeffdaro
Date Posted: 27 January 2007 at 1:33am
Originally posted by -boRg- -boRg- wrote:

The SQL has been performance tuned and the number of database hits have been kept to a minimum...


Borg...I've seen you mention this a few times, and each time I wonder why you have not moved the queries to Stored Procedures. Your performance gains would be immense and the code maintenance would be so much easier.

I had MOD'ed 7.x to use all SP's, but I have not done so on 8.x. Any thoughts on this for 9x?



Posted By: dfrancis
Date Posted: 27 January 2007 at 5:01am
I've always wondered about the RTE images... it seems they don't cache and have to be transfered on each page view. Any insight?

-------------
“If you want things to be different, you must be willing to do different things!” http://www.DavidFrancis.org/?wwf=signature" rel="nofollow - David Francis





Posted By: Melkor
Date Posted: 27 January 2007 at 5:47am
Originally posted by jeffdaro jeffdaro wrote:


Borg...I've seen you mention this a few times, and each time I wonder why you have not moved the queries to Stored Procedures. Your performance gains would be immense and the code maintenance would be so much easier.

I had MOD'ed 7.x to use all SP's, but I have not done so on 8.x. Any thoughts on this for 9x?



I have found that SP's can cause transaction deadlocks if more than one is used per page for large load sites.

Even the few SP's your SYBG Mod uses has occasionally caused TD's on LotRPlaza since I  put it up and I am in the process of converting it to a non-SP version utilizing the rsCommon already open.


Posted By: cyberax
Date Posted: 27 January 2007 at 5:53am

For performance always try to have just one recordset object open at a time. This really boosts the performance.

Regards,


Posted By: WebWiz-Bruce
Date Posted: 27 January 2007 at 1:54pm
Originally posted by jeffdaro jeffdaro wrote:

Originally posted by -boRg- -boRg- wrote:

The SQL has been performance tuned and the number of database hits have been kept to a minimum...


Borg...I've seen you mention this a few times, and each time I wonder why you have not moved the queries to Stored Procedures. Your performance gains would be immense and the code maintenance would be so much easier.

I had MOD'ed 7.x to use all SP's, but I have not done so on 8.x. Any thoughts on this for 9x?



Version 7 used Stored Procedures for the SQL Server version but these where dropped for version 8 as they coursed allot of problems for many users when trying to upgrade between versions. The extra performance gain was minimal and actually found could produce faster performing SQL queries by producing dynamic queries on the fly for many of the pages. This also allowed for greater flexibility in producing dynamic queries.


-------------
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: MrMellie
Date Posted: 27 January 2007 at 3:06pm
Originally posted by cyberax cyberax wrote:

For performance always try to have just one recordset object open at a time. This really boosts the performance.
Where in WWF is there ever more than one recordset open? There is one recordset variable, rsCommon. It's only ever open once at any time.

Regards using stored procedures, I've seen this hotly debated on other forum software sites. The concensus seems to be (and being backed up by performance tests)that there is no performance gain by switching to stored procedures but they do make maintenance more painful.

I agree the pagination isn't perfect, but I can't see how else to improve it. Melkor's site shows how it can start to suffer with the members list having to pull back 80,000 records to display just 25 and this takes 3-4 seconds. Even a SP will have to initially pull off those 80,000 records before it submits the final 25 for the page. This is an extreme example though. For me and my forum, I really can't see it being an issue.



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