PDA

View Full Version : Question for statshounds



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

PY 222
10-27-2004, 12:13 PM
28 days should be sufficient for me.

Thanks for all your hard work Bok. You've always made my day when I look at my stats.


/me heads off to the stats site :thumbs:

wirthi
10-27-2004, 03:16 PM
I really like stats (especially yours :) ) but I usually don't care about really old values. Usually a week, max a month is enough. The thing I really like about third party stats is the "who threads whom" thinggy ... calculated on a per month basis for example.