We run a set of queries to generate "summary" tables for the leaderboards. This allows read access at lightning speed because we are only selecting from a subsection of the total. The problem (or future problem) is that the generation of these tables is a bit slow. I'm hoping someone better at SQL than me can help optimize them.
http://pastebin.com/UZMCpCc9