Short, but one of the most challenging, updates today (announced by Twitter a short while ago, but I will keep posting updates here).
It isn't the country statistics, that's further off - presentation issues. It is something that is currently non-demographic related
Top monthly changes
Top monthly change - akin to Miss MFC, but instead of indicating earning power and therefore featuring a small set of "top models" on a regular basis - it is
camscore change during a month (+ve only). I liked this idea because it isn't necessarily (especially in the % table) going to be dominated by the Top Models - but by those struggling ones who are nearly always overlooked.
This means models who may never see top 1000, let alone top 20, could potentially hit Number 1 in a month for Top % Camscore change - and that I loved. This way we do not miss out on impressive rises for those who may battle hard to increase their score. Rising from 200 to 950 during May would have seen a model hit Number 1 for % change
Sadly, the DB doesn't have those ladies on records - so get submitting!
Again, not the most beautiful presentation of the page I admit - but I've never been great at design. Indeed, I suck.
Right now, the monthly table is querying a database. Later I will "fix" these permanently in html (no point repeating queries for data that is never going to change). It is left at present so I can simply alter the numbers etc as required...
I have no intention of showing realtime currently monthly change. The queries involved in generating this data for 6000 models can (possibly due to my poor db querying, but more likely due to mysql's really poor recognition of optimisation of subqueries) take approx 10 minutes. Even running once per day, I can't be arsed at present
So it'll only be run once per month to generate a second table, which holds the monthly data.
Right now I could display all 5950 models in both actual, and % changes, if required... the data
is there - for now, so let me know if you would like more, less, or options to see up to x rows. There may be potential to do it for countries, although currently I've not planned for that!
As months pass, and more are added, presentation may be an issue - but until then, I hope people like this addition - and comments are always very very welcome