Merge lp:~rvb/launchpad/bugs-timeout-bug-892820 into lp:launchpad
Proposed by
Raphaël Badin
Status: | Merged | ||||
---|---|---|---|---|---|
Approved by: | Raphaël Badin | ||||
Approved revision: | no longer in the source branch. | ||||
Merged at revision: | 14409 | ||||
Proposed branch: | lp:~rvb/launchpad/bugs-timeout-bug-892820 | ||||
Merge into: | lp:launchpad | ||||
Diff against target: |
47 lines (+14/-17) 1 file modified
lib/lp/bugs/model/bugtask.py (+14/-17) |
||||
To merge this branch: | bzr merge lp:~rvb/launchpad/bugs-timeout-bug-892820 | ||||
Related bugs: |
|
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Benji York (community) | code | Approve | |
Review via email: mp+83631@code.launchpad.net |
Commit message
[r=benji][bug=892820] Avoid joins in a subquery to improve performance.
Description of the change
This branch refactors one of the subqueries used by Distribution:+bugs to use subsubqueries instead of joins. This is based on the analysis done by Rob (see bug report). The original and the refactored query https:/
= Tests =
None.
= Q/A =
We can only be sure that this fixes the timeout by testing the performance of the new query on qastaging.
Main query: [8849.0, 8895.0, 8871.0]
Main query: [8898.0, 6006.0, 4913.0]
To post a comment you must log in.
Looks good.