gistfile1.txt

+--------------------------------------------------------+
|   Name   | Time (ms) | Requests/s | IO (KB/s) | Errors |
+--------------------------------------------------------+
| baseline | 1310.3    | 0.8        | 3.9       | 14     |
+--------------------------------------------------------+
+-----------------------------------------------------------------------------------------------------------------------------------------------+
| % Baseline |                                        Name                                        | Time (ms) | Requests/s | IO (KB/s) | Errors |
+-----------------------------------------------------------------------------------------------------------------------------------------------+
| 1.11929    | Using named scopes for late recommendations                                        | 1466.6    | 0.7        | 3.5       | 14     |
| 1.17813    | Actually implementing  named scopes for late recommendations into controller       | 1543.7    | 0.6        | 3.8       | 14     |
| 1.97291    | Use named scopes to load up the available projects                                 | 2585.1    | 0.4        | 3.9       | 14     |
| 1.15317    | Only grab the uniq projects                                                        | 1511.0    | 0.7        | 3.9       | 14     |
| 1.1421     | Cut the displayed late resolutions to 5                                            | 1496.5    | 0.7        | 3.4       | 14     |
| 1.2201     | Make similar changes to upcoming resolutions                                       | 1598.7    | 0.6        | 3.2       | 14     |
| 0.903686   | Include all kinds of mess with projects lookup                                     | 1184.1    | 0.8        | 4.4       | 14     |
| 1.04579    | Do a final run                                                                     | 1370.3    | 0.7        | 3.7       | 14     |
| 0.893612   | Remove unused 'close' resolutions                                                  | 1170.9    | 0.9        | 4.4       | 14     |
| 1.68099    | Specifically include categories                                                    | 2202.6    | 0.5        | 2.3       | 14     |
| 1.67008    | Specifically include categories                                                    | 2188.3    | 0.5        | 2.3       | 14     |
| 1.53675    | Do NOT specifically include categories                                             | 2013.6    | 0.5        | 2.5       | 14     |
| 1.51752    | More convuluted includes                                                           | 1988.4    | 0.5        | 2.2       | 14     |
| 0.505533   | Actually figure out includes                                                       | 662.4     | 1.5        | 6.5       | 14     |
| 0.27528    | Stop eager loading things I don't need                                             | 360.7     | 2.8        | 12.0      | 14     |
| 1.38907    | I had removed recent activity. Adding it back :/                                   | 1820.1    | 0.5        | 2.5       | 14     |
| 2.78104    | Create complex sql query for getting recently update projects                      | 3644.0    | 0.3        | 1.2       | 14     |
| 4.36404    | Try to improve how versions are looked up                                          | 5718.2    | 0.2        | 0.8       | 14     |
| 1.9871     | Go back to the ruby way of find recent projects and clean up activity view lookups | 2603.7    | 0.4        | 2.0       | 14     |
| 0.899565   | Add appropriate db indexes                                                         | 1178.7    | 0.8        | 4.4       | 14     |
| 1.29146    | Back to trying a more db way to lookup recent projects                             | 1692.2    | 0.6        | 3.1       | 14     |
| 0.816912   | Back to the ruby way of looking up recent projects                                 | 1070.4    | 0.9        | 4.8       | 14     |
| 0.879875   | Try to load version more efficiently                                               | 1152.9    | 0.9        | 4.5       | 14     |
| 1.11799    | Add index to versions table                                                        | 1464.9    | 0.7        | 3.5       | 14     |
| 0.940701   | Back to loading version 'inefficiently' :)                                         | 1232.6    | 0.8        | 4.2       | 14     |
| 1.05258    | Add index to recommendations completed_at and combo of due_at/completed_at         | 1379.2    | 0.7        | 3.7       | 14     |
| 1.08273    | Add index to recommendations completed_at and combo of due_at/completed_at (Again) | 1418.7    | 0.7        | 3.6       | 14     |
| 1.01076    | Remove the extra rec and version indexes                                           | 1324.4    | 0.8        | 3.9       | 14     |
+-----------------------------------------------------------------------------------------------------------------------------------------------+