Merge lp:~cjohnston/qa-dashboard/bootspeed-raw-queries into lp:qa-dashboard

[Chris Johnston]

Reduce the queries for the bootspeed raw data page.

It was brought to my attention today that the bootspeed raw data page loads very slowly. After some initial investigation I noticed that the page has approx 4000 db queries. This small MP took the queries to approx 1350 queries per my testing.

[lp:~cjohnston/qa-dashboard/bootspeed-raw-queries]

705. By Chris Johnston on 2014-01-07

Reduces bootspeed raw data queries

[PS Jenkins bot (ps-jenkins)]

PASSED: Continuous integration, rev:705
http://s-jenkins.ubuntu-ci:8080/job/dashboard-ci/283/
Executed test runs:

Click here to trigger a rebuild:
http://s-jenkins.ubuntu-ci:8080/job/dashboard-ci/283/rebuild

review: Approve (continuous-integration)

[Andy Doan (doanac)]

review: Approve

[Chris Johnston (cjohnston)]

 merge approved

review: Approve

=== modified file 'bootspeed/views.py'
--- bootspeed/views.py	2013-06-28 16:21:15 +0000
+++ bootspeed/views.py	2014-01-07 02:52:33 +0000
@@ -151,7 +151,13 @@
 def machine_raw_data(request, machine_id, arch):
     machine = get_object_or_404(Machine, id=machine_id)
 
-    qs = ImageResult.objects.filter(machine__id=machine_id, image__arch=arch)
+    qs = ImageResult.objects.filter(
+        machine__id=machine_id,
+        image__arch=arch,
+    ).prefetch_related(
+        'image',
+        'machine',
+    )
 
     data = []
     for q in qs: