Print Page | Close Window

Scalability

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


Topic: Scalability
Posted By: ndamico
Subject: Scalability
Date Posted: 28 September 2004 at 12:01pm

Trying to plan for my forum's future and would appreciate some insight.  how large of a WWF has anyone run (SQL)?  right now i pushing over 100 users at a time and have 167092 Posts in 15410 Topics in 37 Forums and i just had my 1 year anniversary.

also, what is the largest (# of posts as well as traffic) forum that runs WWF?

thank you so much!




Replies:
Posted By: dj air
Date Posted: 29 September 2004 at 10:19am
this forum was said to be around 20 meg about 3 months ago, so a few meg on top.

there is roughly 20- 50 on at all times. can dip sometimes.

and you can see how many posts, etc it has on the front page.


Posted By: ndamico
Date Posted: 29 September 2004 at 12:20pm

i'm trying to find out about big WWF's (if there are any).  with the speed problems i'm having i'm concerened about have 200 people online.. i'm over 8k members in a year, my sql db is bout 220 megs..

does anyone know of a big or busy site that runs WWF?  i'm worried about it not being able to handle the load and having to migrate to something else...  is there a link of "showcase" wwf forums out there?  this forum isn't busy enough to show the load.. i know when i switched it iportal (test migration, not going to do it for real i don't think) it was much slower too, but i expected that with the overhead from the extra features...



Posted By: ndamico
Date Posted: 05 October 2004 at 6:53pm

Can anyone point me in the direction of a large WWF forum?



Posted By: dpyers
Date Posted: 06 October 2004 at 8:38am

You might just be the big guy on the block.

There was a thread 3-4 months back by someone who had rewritten a lot of the SQL into stored procs and reduced the number of calls used. IIRC, he claimed significant performance improvements. You may want to try locating that thread and contacting him. He struck me as being helpful and willing to share.



-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: xeerex
Date Posted: 06 October 2004 at 9:37am
Well my largest forum isn't quite as big as your current; however, I have over 12k members and here are my stats:

================
Launch Date of Site: February 4th, 2004 (244 days of operation)
We have 3816 Posts in 662 Topics in 21 Forum(s)
Avg Posts Per Day: 15.64
We have 12368 Forum Members
Avg New Members per day: 50.64 (excluding today)
New Members today (so far): 11 | Yesterday: 40
# of Members Visiting Site Today: 329 (excluding new members)
=================

I usually have a minimum of 20 active members showing and have peaked at 150 sustained for over 4 hours.

Oh yeah...I guess I should mention that mine is running on Access.

One of the largest WWG's I've seen is the one at

  www.terminator3.com/forum - www.terminator3.com/forum

I did a quick check and the number of posts was ~115k. Of course it is running v6 of the forum and has been there for well over a year. They need to upgrade it desperately, but people are still posting away.



-------------
http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers?
http://www.smartergeek.com - web design | pc support | training | podcasts | video production


Posted By: ndamico
Date Posted: 08 October 2004 at 3:05am
Originally posted by dpyers dpyers wrote:

You might just be the big guy on the block.

There was a thread 3-4 months back by someone who had rewritten a lot of the SQL into stored procs and reduced the number of calls used. IIRC, he claimed significant performance improvements. You may want to try locating that thread and contacting him. He struck me as being helpful and willing to share.

well i searched, but couldn't find anything except a few mentions of default.asp making way to many calls to the database..

i do get crazy amounts of these in my performance monitor:

300,000 lock requests/sec, up to 40,000 index/searches a sec, almost 200 logins/sec & logouts/sec and >90% processor utilization by sql server..  keeps getting worse and worse over time.. new dual P4 server didn't help much either..



Posted By: theSCIENTIST
Date Posted: 08 October 2004 at 4:48pm
Originally posted by ndamico ndamico wrote:

...I do get crazy amounts of these in my performance monitor: 300,000 lock requests/sec, up to 40,000 index/searches a sec, almost 200 logins/sec & logouts/sec and >90% processor utilization by sql server..  keeps getting worse and worse over time.. new dual P4 server didn't help much either..


What? What else do you run on the server? How much memory?

-------------
:: http://www.mylittlehost.com/ - www.mylittlehost.com


Posted By: dboy
Date Posted: 09 October 2004 at 11:06pm

 

Here are my question in the past
Heavy load for the Web Wiz Forums

And here is lastest my forum statistic

SQL Server DB Size: 127.25 MB

 

Number of Forums 49    
Number of Topics 7357 Last New Topic 10 ตุลาคม 2547, 10:03
Number of Posts 108238 Last New Post 10 ตุลาคม 2547, 10:03
Number of Members 3688 Last New Member 9 ตุลาคม 2547, 19:09
Number of Private Messages 6999

 

I still have speed problem when concurrent user up to 80 , forum slow down and function search not work , always time out.

I no choice , plan to clear  old topic in soon.

 




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