General F@H Database Statistics
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).
|Time To Process
The number of teams may be above 6,000 (currently processing 6,771) because I only prune lower-ranking teams & members once in a blue moon.
As you can see there are 576,563 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!
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.