Person:+archivesubscriptions timeouts (late evaluation)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Abel Deuring |
Bug Description
https:/
OOPS-1950CQ433
The culprit is 7 seconds running repeated 100ms queries. Making the queries 20% faster or more (or doing one query thats slightly slower but not repeated) should solve this.
4 61 6994 114 6880 SQL-launchpad-
SELECT $INT
FROM
(SELECT ArchiveSubscrib
FROM ArchiveSubscriber
WHERE ArchiveSubscrib
(SELECT TeamParticipati
FROM ArchiveSubscriber, TeamParticipation
WHERE TeamParticipati
AND TeamParticipati
AND ArchiveSubscrib
AND ArchiveSubscrib
Related branches
- Curtis Hovey (community): Approve (code)
-
Diff: 168 lines (+45/-54)2 files modifiedlib/lp/soyuz/interfaces/archivesubscriber.py (+3/-5)
lib/lp/soyuz/model/archivesubscriber.py (+42/-49)
Changed in launchpad: | |
status: | New → Triaged |
importance: | Undecided → Critical |
summary: |
- /people/+me/+archivesubscriptions will timeout with many subscriptions + Person:+archivesubscriptions timeouts (late evaluation) |
description: | updated |
Changed in launchpad: | |
assignee: | nobody → Abel Deuring (adeuring) |
status: | Triaged → In Progress |
tags: |
added: qa-ok removed: qa-needstesting |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
Fixed in stable r12998 <http:// bazaar. launchpad. net/~launchpad- pqm/launchpad/ stable/ revision/ 12998>.