| Author |
 Topic Search  Topic Options
|
neryxw 
Newbie
Joined: 21 November 2008
Status: Offline
Points: 8
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: how many forums WebWiz allowed
Posted: 25 November 2008 at 11:16pm |
if I have 100,000,000,00 forums on the web wiz forums system, is that allowed? do you think it will make server very slow, or it will take 90% on server CPU to run this system, espeally when bounch people at same time to search forums .
Can somebody answer this question????  |
 |
Nick-V
Senior Member
Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 November 2008 at 12:55am |
|
How will your members choose which forum to post in LOL !
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 November 2008 at 9:13am |
|
You can have over 1 million posts in Web Wiz Forums SQL Server or mySQL versions no problem.
However having to many forums tends to put people off posting as it splits up people across multipe forums.
May I ask why would you want so many forums?
|
|
|
|
neryxw
Newbie
Joined: 21 November 2008
Status: Offline
Points: 8
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 November 2008 at 5:12pm |
thank you for responding.
I just wondering if I have hurge of number of forums.
My question is : If I have hurge number of forums, will the server uses 97% of CPU or even more ? will it crush the server when many people search and post at the same time ?
thank you
|
|
billd3
Senior Member
Joined: 19 February 2003
Location: United States
Status: Offline
Points: 530
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 November 2008 at 5:23pm |
|
No problem if Bruce hosts your millions of forums! His servers are solid.
We have over 1,500 members, almost 60,000 posts in 7,100 topics in 31 forums.
Small, but solid forum.
|
|
BillD
http://theamcpages.com
http://theamcforum.com
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 November 2008 at 6:31pm |
|
Having millions of forums on the one instance should not overload the server as it is the same as having millions of posts.
The index page of the forum is highly optimised to run just a single SQL query to get all the data needed to list all the forums.
However, the limitation you will probably hit is that all the forums are listed on one page, trying to display all the forums on a single page would probably reach the limit of the ASP response object as there would be to much data for it to be able to send to the web browser.
This would not course the server to run at 100% CPU or other resources, in fact it would not effect performance on the server but would result in an error message being sent to the web browser.
The only way to get around this would be to re-code the forums main frontpage so that it displayed the forums over multiple pages.
You would also need to change any CInt's to CLng's, apart from these changes Web Wiz Forums should run out the box with this number of forums.
|
|
|
|
neryxw
Newbie
Joined: 21 November 2008
Status: Offline
Points: 8
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 November 2008 at 7:21am |
|
Thank you so much for your responding. that was really good answer.
|
|
