Home | Reviews | Forums | Downloads | EXTREME Deals | Comparison Shopping | Free Magazines | Folding Stats Newsletters | Contact Us
FAH Stats
Update: Current
07.29.14, 6pm CDT
Time Now: 7:55pm
Next Run: 64 min




All Donations Help With Server Expenses & Future Features
upward-identification
UPDATE: Monday, March 10th 2014 The front page has been updated with new information!

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).

 

Update Statistics
Newest Update 07.29.14, 6:00pm
Time To Process 12 min
Oldest Update 05.01.04, 12:00am
Total Updates 29,843
Total Days 3,730.375

 

The number of teams may be above 6,000 (currently processing 6,242) because I only prune lower-ranking teams & members once in a blue moon. As you can see there are 554,237 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 6,242 1 MB
Team Historical 32,278,057 1.2 GB
User Current 554,237 72.5 MB
User Historical 798,738,737 28.4 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.

Folding Stats 2.3.0
Copyright 2000-2014 EXTREME Overclocking. All rights reserved.
Disclaimer of Liability - Privacy Policy
Page generated in 0.003 seconds (47.09% PHP - 52.91% MySQL) with 6 queries. 179KB of memory used.
Secret Forum