New Stats Section

Space Goat · 03-10-2009, 01:19 AM

I've finally added the stats section. I actually coded most of this over a year ago, and filed it away for some reason that I can't even remember anymore.

I devised a scheme that caches every query in a separate database table. These caches expire after 24 hours, meaning that a particular query can only be run no more than once a day. This prevents people from inadvertently hammering the server to death with resource intensive queries. However, it also causes thread and post counts to not really be 'live', despite being dynamically generated. I doubt you'll notice though.

Enjoy.

http://www.3dmm.com/stats.php

03-10-2009, 01:19 AM	#1
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	New Stats Section I've finally added the stats section. I actually coded most of this over a year ago, and filed it away for some reason that I can't even remember anymore. I devised a scheme that caches every query in a separate database table. These caches expire after 24 hours, meaning that a particular query can only be run no more than once a day. This prevents people from inadvertently hammering the server to death with resource intensive queries. However, it also causes thread and post counts to not really be 'live', despite being dynamically generated. I doubt you'll notice though. Enjoy. http://www.3dmm.com/stats.php