Web Wiz Support and Community Forums : Scalability https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 05:06:11 +0000 Sat, 09 Oct 2004 23:06:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=11971 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Scalability : Here are my question in the...]]> https://forums.webwiz.net/scalability_topic11971_post67194.html#67194 Author: dboy
Subject: 11971
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 Forums49   
Number of Topics7357 Last New Topic10 ตุลาคม 2547, 10:03
Number of Posts108238 Last New Post10 ตุลาคม 2547, 10:03
Number of Members3688 Last New Member9 ตุลาคม 2547, 19:09
Number of Private Messages6999

 

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.

 

]]> Sat, 09 Oct 2004 23:06:54 +0000 https://forums.webwiz.net/scalability_topic11971_post67194.html#67194 <![CDATA[Scalability : ndamico wrote:...I do get crazy...]]> https://forums.webwiz.net/scalability_topic11971_post67123.html#67123 Author: theSCIENTIST
Subject: 11971
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?]]> Fri, 08 Oct 2004 16:48:28 +0000 https://forums.webwiz.net/scalability_topic11971_post67123.html#67123 <![CDATA[Scalability : dpyers wrote: You might just...]]> https://forums.webwiz.net/scalability_topic11971_post67076.html#67076 Author: ndamico
Subject: 11971
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..

]]> Fri, 08 Oct 2004 03:05:08 +0000 https://forums.webwiz.net/scalability_topic11971_post67076.html#67076 <![CDATA[Scalability : Well my largest forum isn&#039;t...]]> https://forums.webwiz.net/scalability_topic11971_post66995.html#66995 Author: xeerex
Subject: 11971
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

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

]]> Wed, 06 Oct 2004 09:37:26 +0000 https://forums.webwiz.net/scalability_topic11971_post66995.html#66995 <![CDATA[Scalability : You might just be the big guy...]]> https://forums.webwiz.net/scalability_topic11971_post66994.html#66994 Author: dpyers
Subject: 11971
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.

]]> Wed, 06 Oct 2004 08:38:02 +0000 https://forums.webwiz.net/scalability_topic11971_post66994.html#66994 <![CDATA[Scalability : Can anyone point me in the direction...]]> https://forums.webwiz.net/scalability_topic11971_post66971.html#66971 Author: ndamico
Subject: 11971
Posted: 05 October 2004 at 6:53pm

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

]]> Tue, 05 Oct 2004 18:53:57 +0000 https://forums.webwiz.net/scalability_topic11971_post66971.html#66971 <![CDATA[Scalability : i&#039;m trying to find out about...]]> https://forums.webwiz.net/scalability_topic11971_post66577.html#66577 Author: ndamico
Subject: 11971
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...

]]> Wed, 29 Sep 2004 12:20:16 +0000 https://forums.webwiz.net/scalability_topic11971_post66577.html#66577 <![CDATA[Scalability : this forum was said to be around...]]> https://forums.webwiz.net/scalability_topic11971_post66564.html#66564 Author: dj air
Subject: 11971
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.
]]> Wed, 29 Sep 2004 10:19:36 +0000 https://forums.webwiz.net/scalability_topic11971_post66564.html#66564 <![CDATA[Scalability : Trying to plan for my forum&#039;s...]]> https://forums.webwiz.net/scalability_topic11971_post66504.html#66504 Author: ndamico
Subject: 11971
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!

]]> Tue, 28 Sep 2004 12:01:56 +0000 https://forums.webwiz.net/scalability_topic11971_post66504.html#66504