Home | Reviews | EOC Forums | File Downloads | RealTime Pricing Engine | Free Magazines | Folding Stats Contact Us
FAH Stats
Update: Current
09.01.14, 9pm CDT
Time Now: 11:19pm
Next Run: 41 min




All Donations Help With Server Expenses & Future Features


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 09.01.14, 9:00pm
Time To Process 10 min
Oldest Update 05.01.04, 12:00am
Total Updates 30,116
Total Days 3,764.500

 

The number of teams may be above 6,000 (currently processing 6,270) because I only prune lower-ranking teams & members once in a blue moon. As you can see there are 555,959 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,270 1 MB
Team Historical 32,648,614 1.2 GB
User Current 555,959 73.5 MB
User Historical 844,496,809 30.1 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 (56.78% PHP - 43.22% MySQL) with 6 queries. 177KB of memory used.
Secret Forum