Content Dashboard loads slowly

[mrferris]

http://glados.ethportal.net/content/ loads slowly.

The endpoint for this page has 8 queries. The time they currently take (with 3.9 mil audit rows) are as follows:

Content ID: 120 ms
Content: 1641 ms
Audits: 451 ms
Successes: 303 ms
Failures: 377 ms
Hour stats: 941 ms
Day stats: 938 ms
Week stats 958 ms
= 5729 ms

The two priorities should be improving

• "Content" which is the most recent content that has been audited
• Stats, note that this is with Improve scalability of stat calculations #134 so despite being sped up it's still a second per stat period.

[mrferris]

#119 will improve the speed of some of these via indexes, but will require wiping of DB so wanted to note load times now to be compared with once we reach this DB scale again with proper indexes.