Person +packages page should be batched
Bug #43020 reported by
Diogo Matsubara
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Launchpad itself |
Fix Released
|
Medium
|
Julian Edwards | ||
Bug Description
The person +packages page[1] displays all maintained packages of a given person. Currently that list is unbatched and issues the following queries many times:
SELECT COUNT(*) FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND BugTask.status IN (10,20,22,15,25) AND BugTask.
SELECT COUNT(*) FROM Ticket WHERE status = 10 AND distribution = 1 AND sourcepackagename = 33901
Looking at [2] that page generates 184 repeated queries twice.
The page often soft times out and to minimize this problems should be batched and possibly use prejoin.
[1] https:/
[2] OOPS-123C164
| Changed in launchpad: | |
| status: | Unconfirmed → Confirmed |
| description: | updated |
| Changed in launchpad: | |
| assignee: | nobody → kiko |
Revision history for this message
| Christian Reis (kiko) wrote | #1 |
| Changed in launchpad: | |
| assignee: | kiko → nobody |
Revision history for this message
| Julian Edwards (julian-edwards) wrote | #2 |
| Changed in soyuz: | |
| milestone: | none → 2.1.8 |
| status: | Confirmed → Fix Released |
| assignee: | nobody → julian-edwards |
To post a comment you must log in.
I think this is no longer causing timeouts since the redesign, but having a batched page to show the history would be nice..