Web Wiz Support and Community Forums : Is WebWizForums Scalable

Web Wiz Support and Community Forums : Is WebWizForums Scalable https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 08:09:25 +0000 Sat, 27 Jan 2007 15:06:32 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22463 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Is WebWizForums Scalable : cyberax wrote:For performance...]]> https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119901.html#119901 Author: MrMellie
Subject: 22463
Posted: 27 January 2007 at 3:06pm

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.

]]> Sat, 27 Jan 2007 15:06:32 +0000 https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119901.html#119901 <![CDATA[Is WebWizForums Scalable : jeffdaro wrote: -boRg-...]]> https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119897.html#119897 Author: WebWiz-Bruce
Subject: 22463
Posted: 27 January 2007 at 1:54pm

jeffdaro wrote:

-boRg- wrote:

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

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.
]]> Sat, 27 Jan 2007 13:54:09 +0000 https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119897.html#119897 <![CDATA[Is WebWizForums Scalable : For performance always try to...]]> https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119887.html#119887 Author: cyberax
Subject: 22463
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,

]]> Sat, 27 Jan 2007 05:53:00 +0000 https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119887.html#119887 <![CDATA[Is WebWizForums Scalable : jeffdaro wrote: Borg...I've...]]> https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119886.html#119886 Author: Melkor
Subject: 22463
Posted: 27 January 2007 at 5:47am

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.

Edited by Melkor - 27 January 2007 at 7:23am]]> Sat, 27 Jan 2007 05:47:47 +0000 https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119886.html#119886 <![CDATA[Is WebWizForums Scalable : I've always wondered about...]]> https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119885.html#119885 Author: dfrancis
Subject: 22463
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?]]> Sat, 27 Jan 2007 05:01:34 +0000 https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119885.html#119885 <![CDATA[Is WebWizForums Scalable : -boRg- wrote:The SQL has...]]> https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119877.html#119877 Author: jeffdaro
Subject: 22463
Posted: 27 January 2007 at 1:33am

-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?

]]> Sat, 27 Jan 2007 01:33:04 +0000 https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119877.html#119877 <![CDATA[Is WebWizForums Scalable : Hey! I know that site! Hehe!As...]]> https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119669.html#119669 Author: Melkor
Subject: 22463
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.
]]> Mon, 22 Jan 2007 03:58:28 +0000 https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119669.html#119669 <![CDATA[Is WebWizForums Scalable : That shouldn't be a problem,...]]> https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119651.html#119651 Author: WebWiz-Bruce
Subject: 22463
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/

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.

Edited by -boRg- - 21 January 2007 at 6:18pm]]> Sun, 21 Jan 2007 18:17:40 +0000 https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119651.html#119651 <![CDATA[Is WebWizForums Scalable : Hi Borg, What you think how much...]]> https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119631.html#119631 Author: cyberax
Subject: 22463
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,

]]> Sat, 20 Jan 2007 19:36:35 +0000 https://forums.webwiz.net/is-webwizforums-scalable_topic22463_post119631.html#119631