oops repeat queries in productseries-milestone-table-row.pt

Bug #490648 reported by Curtis Hovey
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Unassigned

Bug Description

Oops OOPS-1430D437 show two bad things: This bug is about the repeat queries. The root problem is that the PRF, with a very generous glob will add an insane number of release to a series--the PRF probably needs to create series to organise the downloads.

For each milestone that is shown in the milestone table, the release is looked up three times and the structuralsubscription is looked up once, but never used. The MilestoneView provides the release as view/release. The other two uses must use the view's copy. The structuralsubscription is gotten because the navigation menu is used to get the edit link. A new menu is needed that only provides the edit link to ensure the extra db call is made.

Related branches

Curtis Hovey (sinzui)
Changed in launchpad-registry:
assignee: nobody → Curtis Hovey (sinzui)
status: Triaged → In Progress
Curtis Hovey (sinzui)
Changed in launchpad-registry:
milestone: 3.1.11 → 3.1.12
Revision history for this message
Curtis Hovey (sinzui) wrote :

Fixed in launchpad devel r9969.

Changed in launchpad-registry:
status: In Progress → Fix Committed
Revision history for this message
Curtis Hovey (sinzui) wrote : Bug 490648 Fix released

Fixed released in launchpad-project 3.1.12.

Changed in launchpad-registry:
status: Fix Committed → Fix Released
Curtis Hovey (sinzui)
Changed in launchpad:
assignee: Curtis Hovey (sinzui) → nobody
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.