All Donations Help With Server Expenses & Future Features

UPDATE: Tuesday, January 29th 2013 The front page has been updated with new information!

I figured I could make a page giving some rough statistics for database usage & processing time. Some people don't fully realize the scope of these stats and the enormous amount of data that is being stored and processed. I'll try to add more info to this page when I think of new things (or people email me with suggestions).

Update Statistics
Newest Update	05.21.13, 9:00am
Time To Process	14 min
Oldest Update	05.01.04, 12:00am
Total Updates	26,401
Total Days	3,300.125

The number of teams may be above 6,000 (currently processing 7,096) because I only prune lower-ranking teams & members once in a blue moon. As you can see there are 575,815 users being processed, multiply that by 8 updates a day, 7 days a week, 52 weeks a year, and you can see why there are millions of rows of data!

	Rows	Size
Team Current	7,096	1.2 MB
Team Historical	32,627,103	1.2 GB
User Current	575,815	78.2 MB
User Historical	1,512,391,232	45 GB

The historical user data isn't even as large as it *could* be, if a user's points or rank doesn't change then no new data is inserted. Data over a couple months old is pruned down to only 1 update per day max and the excess records are moved to a separate archive table (so the data isn't lost). One day I hope to add more stats pages so that a person can look back at stats from a year ago (or longer), and see how much they have accomplished. Until then the most I can do is just store the data, because if I don't then it is lost.