Distribution:+assignments is taking a long time maybe 20% of the time
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
High
|
Robert Collins |
Bug Description
Distribution:
https:/
https:/
SQL time: 6799 ms
Non-sql time: 11123 ms
Total time: 17922 ms
Statement Count: 208
1 187 6132 32 6100 launchpad-
is the most duplicated query, and seems to be most of the sql time.
Related branches
- Paul Hummer (community): Approve
-
Diff: 227 lines (+89/-54)5 files modifiedlib/lp/blueprints/browser/specificationtarget.py (+6/-0)
lib/lp/blueprints/browser/tests/test_specificationtarget.py (+46/-12)
lib/lp/blueprints/model/specification.py (+28/-39)
lib/lp/blueprints/templates/specificationtarget-assignments.pt (+4/-2)
lib/lp/services/database/prejoin.py (+5/-1)
description: | updated |
description: | updated |
Changed in blueprint: | |
assignee: | nobody → Robert Collins (lifeless) |
Changed in blueprint: | |
status: | Fix Committed → Triaged |
tags: |
added: qa-ok removed: qa-needstesting |
tags: | removed: qa-ok |
Changed in blueprint: | |
milestone: | 10.09 → none |
Changed in blueprint: | |
assignee: | nobody → Robert Collins (lifeless) |
Changed in blueprint: | |
status: | Fix Committed → Fix Released |
This is now down to 76 queries and 13 seconds : not brilliant, but we have some breathing room.