Bok
10-27-2004, 11:22 AM
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
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