January 8, 2009
I’m working on a new set of reports to cover some of the more general decisions that players need to make. Picking professions is a classic example. Professions can be played for fun and profit so it would be useful to know the most popular professions for each class; more useful still to know which combinations of professions are the most popular, since picking two that go together is half the battle, especially at lower levels when cash generation is usually the name of the game.
As people who work with database queries know, there are a couple of tricks to generating combinations from a relational database – we need a query which knows that “skinning/mining” and “mining/skinning” are not two different combinations. But once that problem is solved, it’s all downhill from there.
We end up with tables that look like this. This is the distribution of profession combinations across the total character base:
Combinations that have a popularity below 1% are not shown.
Useful information, but there is nothing too surprising in the table. Hopefully when the data is broken down across classes, some more interesting patterns will emerge.
(BTW I haven’t forgotten that the death knight stats pages aren’t up yet. There have been a couple of technical problems with my new stats queries… Should be fixed in the next day or so.)