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 7,439) because I only prune lower-ranking teams & members once in a blue moon.
As you can see there are 601,795 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.
Unfortunately I've had to prune the tables over the years, and as of right now user data only goes back to 2013, and team data to 2008.
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 as much data as possible, because if I don't then it is lost for good.