| Author |
 Topic Search  Topic Options
|
cyberax 
Newbie
Joined: 26 September 2005
Location: India
Status: Offline
Points: 11
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Is WebWizForums Scalable
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,
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
Melkor
Groupie
Joined: 11 December 2006
Location: United States
Status: Offline
Points: 80
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
jeffdaro
Groupie
Joined: 15 April 2005
Status: Offline
Points: 171
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
dfrancis
Senior Member
Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442
|
Post Options
Thanks(0)
Quote Reply
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!” David Francis
|
|
Melkor
Groupie
Joined: 11 December 2006
Location: United States
Status: Offline
Points: 80
|
Post Options
Thanks(0)
Quote Reply
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
|
|
cyberax
Newbie
Joined: 26 September 2005
Location: India
Status: Offline
Points: 11
|
Post Options
Thanks(0)
Quote Reply
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,
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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...
|
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.
|
|
|
|
