Doog just said this in chat:
12:22:25 [removed] Doog, biggest.txt seems to be not updating?
12:22:28 [removed] generated Tue Jan 21 19:59:30 UTC 2014
12:22:43 (1) [removed] yeah, I stopped it - it takes far too long and makes the server lag to update it
12:22:55 (1) I should make it just do the easy ones - last hour, etc.
12:23:00 (1) it's the 'last 52 weeks' that kills it
I have a cut-down version of the 'biggest bets' report running now. I need to work out why the queries for the individual biggest bets are so slow, but it the mean time:
biggest cumulative losses in last 12 hours
+--------+-----------------+
| uid | profit |
+--------+-----------------+
| 433249 | -469.36447370 |
| 433434 | -50.44589718 |
| 429041 | -6.85903271 |
| 264535 | -3.24000000 |
| 430204 | -2.99488631 |
| 324992 | -1.58997037 |
| 271269 | -0.99703948 |
| 433183 | -0.96831000 |
| 434709 | -0.63920000 |
| 416920 | -0.56000000 |
+--------+-----------------+
biggest cumulative amount wagered in last 12 hours
+--------+-----------------+
| uid | wagered |
+--------+-----------------+
| 433249 | 3,394.25000000 |
| 419859 | 176.57296154 |
| 433434 | 75.86665616 |
| 409768 | 70.62800000 |
| 264535 | 61.01665532 |
| 165757 | 53.08243584 |
| 352466 | 46.91634000 |
| 425741 | 39.74990531 |
| 433463 | 36.64697555 |
| 411587 | 35.25720000 |
+--------+-----------------+