Ok,

I'm pretty close on my new stats code. Couple of features still to add in, but nothing data related.

One question to ask right now is :

Who is interested in data over 28 days old ?

Currently in my new stats I'm only storing the last 28 days of scores,ranks etc. In the older one it accumulated indefinitely which made the tablesizes get a little unwieldy and slowed down queries over time.

I could write this data to a different table which would probably be ok and only used in historic user stats but am not sure it's really worthwhile.....

Bok