Friday, June 22, 2007

Just under 2.5M characters and Europe info

The armory has been acting wonky for the past few days, so I've suspended data acquisition for now. I've got just under 2,500,000 characters in place, and that's just enUS. I'm in the process of tweaking things to support the EU armory so I should get even more data from there. I'm also redesigining the schema somewhat to improve performance. While I'd like to put up web pages with live queries, I think what will actually happen is daily or weekly runs with result pages. This weekend I'll start running comparisons between the 1M checkpoint and where the data is now.

Wednesday, June 13, 2007

New Build Shop up - Hunter 5/13/43

WoWInsider's Build Shop has a new build up, conveniently enough a hunter build. Let's take a look.

Well, I'm up to almost 2 million characters, and guess what: no one's got this build. In fact, only 45 characters even have this *spec*. Needless to say, none of them share a build. This leads me to believe this build was submitted either as a theory or a joke.

So what have we got? Part of me questions putting points in BM at all if you're going for an uber-CC build, since why do you need to worry about attack speed if your enemies are always under control? I would think those 5 points would be better off in either Mortal Strikes (otherwise why did they bither putting 5 points in Lethal Shots?) or horror of horrors, Imp Stings to pump up Wyvern Sting.

And since we're getting into the MM tree, why no points in Efficiency? Mana's a concern, since you're going to be tossing lots of spells around, so I would think Efficiency would be a priority. Go For the Throat is fine, I guess, but again, given the implied intent of the build, we don't care about damage, we don't care about pets, so putting those points in Imp Feign Death seems like it might be better (I know, Imp FD is bogus, I'm just saying) for dealing with loss of control when 4+ enemies are involved.

Tier 1 in SV is an exercise in trying to get to higher tiers. Sure, two points in Savage Strikes, but the other 3 points can go wherever. I'm guessing Humanoid Slaying was chosen for the same reason Eliah guessed, for PvP. For PvE I'd probably pick Hawkeye too. :P Tier 2 and Tier 3 are more of the same, Entrapment, Imp Wing Clip and Clever Traps are necessary. 5 points in Survivalist is tier fodder and extra health can't hurt. Trap Mastery is key to the intent, Survival Instincts and Killer Instinct are tier fodder but are the best of what's available. Resourcefulness is key for long fights. Lightning Reflexes gets you to Wyvern Sting, so you might as well grab Expose Weakness for more damage and to get you up to Master Tactician and Readiness. I would think that filling out Thrill of the Hunt would be useful (again, the whole mana thing) but overall I feel this is a build to mess around with and not a particularly serious one.

Monday, June 11, 2007

1st Million - Warriors

44,771 level 70 warriors in the first million. The largest represented class. Not hunters, not mages... warriors:
  1. 8/5/48 - 2652 (5.92%)
  2. 31/30/0 - 1871 (4.18%)
  3. 35/23/3 - 1693 (3.78%)
  4. 5/5/51 - 1492 (3.33%)
  5. 33/28/0 - 1269 (2.83%)
  6. 17/44/0 - 1194 (2.67%)
  7. 8/0/53 - 1075 (2.40%)
  8. 41/20/0 - 1014 (2.26%)
  9. 11/0/50 - 994 (2.22%)
  10. 5/0/56 - 812 (1.81%)

4 Arms specs, 1 Fury spec, and 5 Protection specs. Being a tank class, this breakdown is expected.

  • Arms - 16708 (37.3%)
  • Fury - 6466 (14.4%)
  • Protection - 21472 (47.9%)
  • Nospec'd - 125 (0.2%)
  • Unspec'd - 7 (0.01%)

1st Million - Warlocks

Warlocks! There's 34,001 of them in the first million. Here we go:
  1. 43/7/11 - 1224 (3.60%)
  2. 20/41/0 - 1072 (3.15%)
  3. 7/43/11 - 1024 (3.01%)
  4. 41/0/20 - 1010 (2.97%)
  5. 45/5/11 - 902 (2.65%)
  6. 40/0/21 - 826 (2.43%)
  7. 0/21/40 - 778 (2.29%)
  8. 43/0/18 - 633 (1.86%)
  9. 42/8/11 - 624 (1.84%)
  10. 42/19/0 - 594 (1.75%)

7 Affliction specs, 2 Demonology specs, and 1 lone Destruction spec. Ok, let me see if I can say this right: So far, of all the classes, the Warlock top spec has the lowest percentage of any other class. This can be a good or bad thing. Either the warlock talents are so good, characters can spec a number of different ways and still be very effective, or warlocks are nubs and don't understand their own class and are top notch at PvP by accident. I'll go with the latter just to piss off Inowar. I note with amusement that his spec is not in the top 10.

Anyhoo, here's the spec breakdown:

  • Affliction - 15384 (45.2%)
  • Demonology - 10887 (32.0%)
  • Destruction - 7501 (22.06%)
  • Unspec'd - 229 (0.6%)
  • Nospec'd - 4 (0.01%)

Update - Yeah, that second spec was a typo, it's 20/41/0.

1st Million - Shamans

19,581 shamans, the least represented class at 70. Here we go:
  1. 0/5/56 - 2922 (14.92%)
  2. 40/0/21 - 1753 (8.95%)
  3. 41/0/20 - 986 (5.04%)
  4. 0/40/21 - 924 (4.72%)
  5. 0/42/19 - 767 (3.92%)
  6. 0/11/50 - 596 (3.04%)
  7. 0/0/61 - 575 (2.94%)
  8. 0/41/20 - 453 (2.31%)
  9. 0/7/54 - 363 (1.85%)
  10. 0/45/16 - 301 (1.54%)

2 Elemental specs, 4 Enhancement specs, and 4 Restoration specs. Unsurprisingly, the only single tree spec is in Restoration (go go healer!). Overall the spec breakdowns are:

  • Elemental - 5145 (26.2%)
  • Enhancement - 6565 (33.5%)
  • Restoration - 7852 (40.1%)
  • Unspec'd - 19 (0.09%)
  • Nospec'd - 3 (0.01%)

1st Million - Rogues

38,128 rogues. 90 more rogues than hunters in the first million. Check out the specs:
  1. 15/41/5 - 2755 (7.23%)
  2. 41/20/0 - 2057 (5.39%)
  3. 17/44/0 - 1951 (5.12%)
  4. 13/41/7 - 1857 (4.87%)
  5. 19/42/0 - 1736 (4.55%)
  6. 41/0/20 - 1445 (3.79%)
  7. 30/0/31 - 1279 (3.35%)
  8. 20/41/0 - 1174 (3.08%)
  9. 21/0/40 - 831 (2.18%)
  10. 16/45/0 - 793 (2.08%)

A reasonably healthy distribution (that is to say, all three tree are represented) of specs. Combat rules the board with 6 specs, followed by 2 each of Assassination and Subtlety. 9886 rogues are spec'd Assassination. 18267 are spec'd for Combat and 9042 are spec'd for Subtlety. 933 rogues are unspec'd and 9 rogues aren't spec'd at all.

1st Million - Priests

Healers! Every party needs them. Out of the first million, 36,205 level 70 priests exist. Let's take a look at the numbers:

  1. 23/38/0 - 3947 (10.9%)
  2. 28/33/0 - 3102 (8.57%)
  3. 21/40/0 - 2534 (7.00%)
  4. 14/0/47 - 2479 (6.85%)
  5. 11/0/50 - 1232 (3.40%)
  6. 31/30/0 - 1086 (3.00%)
  7. 20/41/0 - 952 (2.63%)
  8. 0/0/61 - 947 ( 2.62%)
  9. 13/0/48 - 890 (2.46%)
  10. 10/0/51 - 882 (2.44%)

5 Holy/Discipline specs, 4 Shadow/Discipline specs, and the scourge of the priestly nation, the full-on Shadow spec. Unsurprisingly Holy/Disc takes the tops spots, but Shadow makes a strong showing as well. And when looking a specs overall, Holy keeps the lead with 17,376 priests (48%) with Shadow coming a close second at 14,054 priests (38.8%) and Discipline crossing the finish line a few minutes later with 4,602 priests (12.7%). That leaves 173 priests who can't make up their minds, and 2 who are completely out of the loop with no talent points spent.

1st Million - Paladin

If hardcore raiders are to be believed, paladins are the new priests. There are 27,538 level 70 paladins, and without further ado, the breakdown:

  1. 41/20/0 - 3821 (13.88%)
  2. 50/11/0 - 1776 (6.45%)
  3. 43/18/0 - 1516 (5.51%)
  4. 42/19/0 - 1164 (4.23%)
  5. 47/14/0 - 942 (3.42%)
  6. 44/17/0 - 821 (2.98%)
  7. 45/11/5 - 751 (2.73%)
  8. 45/16/0 - 726 (2.64%)
  9. 48/13/0 - 696 (2.53%)
  10. 0/49/12 - 576 (2.09%)

Well, well, well. The top 10 specs represent 46.4% of the class, and not a single Retribution spec to be seen. Apparently the 3,713 Retribution paladins (13.5%) left aren't much in agreement. The only one that's not Holy is in 10th place, with a focus on Protection. And speaking of Protection, there's only 3,981 Protection paladins (14.5%), and 19,691 pallies (a whopping 71.5%!) are Holy-spec'd. 153 paladins have no spec at all, and 4 people either haven't realized they got a free respec some time ago, or are so hardcore they don't need talents to crush.

Wednesday, June 6, 2007

1st Million - Mages

Mages, or as some would say, the real "glass cannons" make up 42,448 of our level 70 pool. Let's get right to the numbers:

  1. 40/21/0 - 3859 (9.09%)
  2. 10/48/3 - 3187 (7.51%)
  3. 40/0/21 - 3120 (7.35%)
  4. 0/0/61 - 2172 (5.12%)
  5. 33/28/0 - 1711 (4.03%)
  6. 17/0/44 - 1611 (3.80%)
  7. 10/0/51 - 1392 (3.28%)
  8. 41/20/0 - 1261 (2.97%)
  9. 21/40/0 - 983 (2.32%)
  10. 2/0/59 - 950 (2.24%)

Some interesting numbers pop out from the builds. Only 3 of the 100 builds here exceed 1% of the class in size, and 2 of them are 10/48/3. The only difference between those 2 builds is a single point in Fire. The top build takes 1/3 Improved Fire Blast, and second place goes to a 1/2 Blazing Speed. And to even further show consolidation, third place puts that point in 1/5 Impact.

The third build that exceeds 1% of the class size is 0/0/61, full on Frostiness. You really can't get much deeper than that. (only Frost Warding and Frozen Core are skipped)

In terms of spec, the top 10 leans towards Arcane. 23.4% of mages have a top 10 spec and focus on Arcane. Only 7.5% are Fire, and 14.4% are Frost. As compared to all level 70 mages, of which 40% are Arcane, 31.1% are Fire, and 28.6% are Frost. The remaining 67 of you mages have no specialization at all. (and 8 of those had no talents chosen at all!)

Sunday, June 3, 2007

1st Million - Hunters

The number of level 70 hunters? 38,030, not the least, but far from the most, as detractors would have you believe.




  1. 41/20/0 - 2221 (5.84%)
  2. 0/43/18 - 1574 (4.15%)
  3. 0/45/16 - 1450 (3.81%)
  4. 0/42/19 - 1064 (2.80%)
  5. 0/44/17 - 864 (2.27%)
  6. 0/41/20 - 806 (2.12%)
  7. 7/45/9 - 800 (2.10%)
  8. 0/47/14 - 681 (1.79%)
  9. 5/53/3 - 647 (1.70%)
  10. 5/47/9 - 579 (1.52%)

The amount of variance in the Beast Mastery "cookie-cutter" spec alone is pretty staggering, although 23.6% of all Beast Mastery hunters have it, suggesting not much variance at the spec level. Humorously enough, BRK's current spec is not represented at all in the top 10 builds for this spec. I guess I haven't crawled Madoran yet, so it will be good to see how his build fares when all 3 million or so characters I have get pulled in. The top two builds differ only in the ubiquitous Tier 2 Marksmanship decision: Efficiency or Improved Hunter's Mark? Solo or Raid? 8 out of 10 builds put 2 points in the much maligned Spirit Bond (version 2). Another point of contention seems to be where to put the 5th point for Tier 7 in order to get to Serpent's Swiftness: Bestial Discipline is the most popular resting place, or else a token point Animal Handler or Catlike Reflexes.


As for the rest of the specs, they are completely dominated by Marksmanship builds. From the rather confusing 0/41/20 to the PvP-oriented 0/43/18 to what I consider to be even more degenerate than the "glass cannon", 5/53/3.

I don't even know where to begin. Less than 4% of the hunters that chose 0/41/20 are represented in its top 10, so I can only conclude those that chose this spec are either deluded, misinformed, or just plain ignorant. Diversity is a good thing, but when your top build is shared less than a percent of your spec-mates (as it is with two other specs in the top 10), it's overdoing it. Either that or I'm missing something that might present itself in a PvE vs. PvP server breakdown. Look for that in a future post.

5/53/3 is just plain offensive to me. (Warning, religious zealotry ahead) We as a class are not complete without our pet, so why go so far out of our way to gimp ourselves by gimping our pet? And please, repeat after me: Hawk Eye is a crutch. I'm far from the best hunter around, but I can function just fine without it. There are plenty of other talents that give you more bang for the point. (pun only partially intended)

Ironically enough, it is 5/47/9, the last of our top 10 specs, that has the highest percentage sharing a single build. 21.42% of the only 579 hunters that went this spec chose it, practically 3 times the most popular build of next in line, 7/45/9. (figures. :P)

Am I biased? Hell yeah. I am (well, will be, someday :P) part of the most popular spec for hunters, yet it only represents a small (yet extremely vocal) minority of hunters overall. (68.56% of level 70 hunters are Marksmanship, as opposed to 24.65% opting for Beast Mastery, and a whopping 6.52% are Survival. Even more frightening is the remaining 0.25% (90 of you, and 8 who cleared their talents and haven't respecced yet!) that are of no spec at all, with no possibility of a 31-point, much less 41-point talent.)

A lot of numbers here. In the end, you can't just look at the spec, or at the build level. Context is everything. Hopefully everyone's not too confused to comment.

1st Million - Druids

There are 30,791 level 70 druids in the first million (and change) characters. I'm going to present build information a bit differently this time, by showing the most popular specs, then the most popular builds within those specs. Afterward I'll highlight the most popular build overall, which isn't always what you would expect. The tables are here, with embedded Wowhead talent calculator popups. Unfortunately, I can't get them working on Blogger, probably because of security concerns. For the lazy, I'll summarize the top 10 specs:

  1. 0/47/14 - 3316 (10.7%)
  2. 0/0/61 - 2292 (7.4%)
  3. 0/50/11 - 2215 (7.2%)
  4. 1/46/14 - 1760 (5.7%)
  5. 0/49/12 - 1177 (3.8%)
  6. 0/44/17 - 875 (2.8%)
  7. 1/49/11 - 790 (2.5%)
  8. 1/0/60 - 776 (2.5%)
  9. 0/45/16 - 740 (2.4%)
  10. 0/46/15 - 689 (2.2%)

The top 10 specs collectively account for 14,630 characters, almost half of the level 70 druids. Feral takes the overwhelming majority, accounting for 11,562 characters. Restoration takes up the remaining characters, as Balance gets no love at all. Out of the 3 builds that actually put a point in Balance, only 1 build put a point in something other than Nature's Grasp. Apparently a few people want to get their Wrath and Starfire on a little bit faster. Looking at the full Restoration spec it's pretty amazing just how much variance you can get out of 68 points, Though only 1 build so much as even scratches Furor.

1st Million - Quick Stats

The first million characters (1,008,406 to be exact) are in so I stopped things long enough to crunch some numbers:

311,493 level 70 characters (just under 31%)

Class Breakdown:
  • Druid - 30791
  • Hunter - 38030
  • Mage - 42448
  • Paladin - 27538
  • Priest - 36205
  • Rogue - 38128
  • Shaman - 19581
  • Warlock - 34001
  • Warrior - 44771

Tomorrow (er, after I sleep) I'll start posting information on the most popular specs and builds within those specs.