Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Scalability
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Scalability
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
ndamico View Drop Down
Groupie
Groupie
Avatar

Joined: 03 September 2003
Location: United States
Status: Offline
Points: 46 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ndamico Quote  Post ReplyReply Direct Link To This Post Topic: Scalability
    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!
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
ndamico View Drop Down
Groupie
Groupie
Avatar

Joined: 03 September 2003
Location: United States
Status: Offline
Points: 46 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ndamico Quote  Post ReplyReply Direct Link To This Post 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...
Back to Top
ndamico View Drop Down
Groupie
Groupie
Avatar

Joined: 03 September 2003
Location: United States
Status: Offline
Points: 46 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ndamico Quote  Post ReplyReply Direct Link To This Post Posted: 05 October 2004 at 6:53pm

Can anyone point me in the direction of a large WWF forum?
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
xeerex View Drop Down
Senior Member
Senior Member


Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601 		Post Options Post Options   Thanks (0) Thanks(0)   Quote xeerex Quote  Post ReplyReply Direct Link To This Post 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 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.
Need Hosting, Domains, Dedicated Servers?
web design | pc support | training | podcasts | video production
Back to Top
ndamico View Drop Down
Groupie
Groupie
Avatar

Joined: 03 September 2003
Location: United States
Status: Offline
Points: 46 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ndamico Quote  Post ReplyReply Direct Link To This Post 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..
Back to Top
theSCIENTIST View Drop Down
Senior Member
Senior Member


Joined: 31 July 2003
Location: United Kingdom
Status: Offline
Points: 440 		Post Options Post Options   Thanks (0) Thanks(0)   Quote theSCIENTIST Quote  Post ReplyReply Direct Link To This Post 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?
:: www.mylittlehost.com
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.