Merge lp://staging/~joetalbott/qa-dashboard/sql_optimization into lp://staging/qa-dashboard

Proposed by Joe Talbott
Status: Merged
Approved by: Chris Johnston
Approved revision: 739
Merged at revision: 740
Proposed branch: lp://staging/~joetalbott/qa-dashboard/sql_optimization
Merge into: lp://staging/qa-dashboard
Diff against target: 283 lines (+234/-4)
4 files modified
common/migrations/0012_add_index_Artifact_name.py (+114/-0)
common/migrations/0013_add_index_Artifact_url.py (+114/-0)
common/models.py (+2/-2)
smokeng/views.py (+4/-2)
To merge this branch: bzr merge lp://staging/~joetalbott/qa-dashboard/sql_optimization
Reviewer Review Type Date Requested Status
PS Jenkins bot continuous-integration Approve
Andy Doan (community) Approve
Chris Johnston Approve
Review via email: mp+217927@code.staging.launchpad.net

Commit message

smokeng - Optimize crash gathering code.

Description of the change

smokeng - Optimize crash gathering code.

To post a comment you must log in.
Revision history for this message
Chris Johnston (cjohnston) wrote :

11:14:13 cjohnston | do you have any before and after data?
11:15:10 josepht | it halved the query time for utopic results for me

review: Approve
Revision history for this message
Andy Doan (doanac) wrote :

i did zero investigation, but i was hoping we just needed an index or two added to the db to help this.

review: Approve
Revision history for this message
PS Jenkins bot (ps-jenkins) wrote :

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

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

review: Approve (continuous-integration)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
The diff is not available at this time. You can reload the page or download it.

Subscribers

People subscribed via source and target branches