November 10, 2009 at 3:47 pm
OK, 10 minutes was ambitious. Took me ten minutes to change computers.
I pulled down the post data anonymously, grouping a count by number of posts. I then pulled it into Excel, and graphed it. It's attached, which is useless. If you expand it, you have a very steep logarithmic decline near the 0 post mark (most people have 0 posts) and another expansion near the high end.
I need to group these up into bands and then it might be more meaningful.
November 10, 2009 at 3:53 pm
Try a logarithmic y-axis. Might be clearer.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 10, 2009 at 10:09 pm
I tried a log scale, didn't seem much better. I think it's too many data points and no good distribution.
A few facts:
Users: 972,717 (not all members are in the forum db)
User counts:
0 posts: 861,290
1 post : 25,992
10 or less posts: 940,121
100 or less posts: 965,076
Up to about 300 posts, seems there are double digit users most of the time. Once we get past 300-350, it's mostly single digit users.
If we bucket,
People > 1000 posts: 412 people
> 2000 posts: 88 users
> 3000 posts: 30 users
> 5000 posts: 17 users
> 10,000 posts: 6 users
> 20,000 posts: 1 user :-D:-P:-P
November 11, 2009 at 8:04 pm
I've come a long way since this old post. I think I was a 15 point grasshopper at the time.. 🙂
November 18, 2009 at 10:17 am
Might be more fun to see a window in time ranking, (last year or two?) so that if I posted 10,000 posts in 2005 but haven't been around since then, my stuff gets pulled out of the graph.
i.e. a way to view current troublemakers, erm I mean users, in terms of scores 😛
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 18, 2009 at 4:29 pm
Are these buckets strictly posts or are the QOD points included?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 18, 2009 at 9:45 pm
QOD points as well. We're looking to also add the ASK reputation somehow and calculate some "engagement index"
November 21, 2009 at 9:37 am
Lynn Pettis (11/10/2009)
GilaMonster (11/10/2009)
Andy Llewellyn (11/10/2009)
Did the distribution graph of members at each level ever get published?Don't think so, but it's heavily weighted to the lower end.
There are 15 people with a score over 5000, 4 with a score over 10000
Not much longer and there will be 5!! 😉
Congratulation Lynn for joining the SSC most prolific!
😎
Kind regards,
Gift Peddie
April 4, 2010 at 1:53 pm
GilaMonster (1/28/2008)
Steve Jones - Editor (1/28/2008)
Baseball knowledge probably does help with the levels. I picked these over the summer, so my apologies for outside influences 🙂It's your site. You can do as you wish. I'll give alternatives some thought. Maybe something cricket related? 😉
The explanation is appreciated.
Yes, I too appreciate the explanation.
Here are some cricket-related suggestions for levels. 2 suggestions for now, and maybe another next year, involving players from 3 different countries.
11953 Up with Lara (W Indies)
And, just to keep the southern contingent happy maybe an Australian: 908 : Running with Billy
Next year we might have an Indian one if Sachin Tendulkar retires (currently at 13447 and still going strong).
Tom
April 4, 2010 at 2:02 pm
Tom.Thomson (4/4/2010)
And, just to keep the southern contingent happy maybe an Australian:
Seriously? 😛
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
April 4, 2010 at 3:50 pm
Paul White NZ (4/4/2010)
Tom.Thomson (4/4/2010)
And, just to keep the southern contingent happy maybe an Australian:Seriously? 😛
I couldn't find any NZ cricket numbers that would fit in :ermm:.
Billy Murdoch was captain of Australia towards the end of the 19th century, I think he was the second batsman ever to score an innings of over 300 in a 1st class cricket match. 908 was his total test match score (runs, not matches:hehe:).
Tom
May 14, 2010 at 8:01 am
I just crossed 2K, wahoo! This seemed to be an appropriate place to celebrate becoming "Crazy" 🙂
Chad
May 14, 2010 at 8:42 am
Chad Crawford (5/14/2010)
I just crossed 2K, wahoo! This seemed to be an appropriate place to celebrate becoming "Crazy" 🙂Chad
Congrats (on being crazy)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2010 at 10:21 am
Hey Steve, I just passed 700. How come I'm still "chasing Mays"?
Maybe after 660, it should be "chasing Babe"! 🙂
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
June 9, 2010 at 10:47 am
Probably should have one at 662, any ideas? Maybe "The Say Hey Kid"
The next level is 714, Right There with Babe.
Viewing 15 posts - 31 through 45 (of 56 total)
You must be logged in to reply to this topic. Login to reply