Launchpad itself

Calculating subscribers for bugs with multiple tasks is expensive

Bug #220251 reported by Christian Reis on 2008-04-21

Affects		Status	Importance	Assigned to	Milestone
	Launchpad itself	Fix Released	High	Eleanor Berger

Bug Description

If you look at a bug like https://edge.launchpad.net/launchpad/+bug/219346 you'll notice that it has 20+ tasks. The way the code is structured means that get_bugtask_indirect_subscribers() will be called many times, and each of them, issuing redundant or single-item queries.

It should be possible to calculate all the implicit subs for the bug in a few efficient queries by providing an API like get_bug_indirect_subscribers() (in lieu of get_bugtask_indirect_subscribers()).

Tags:

Eleanor Berger (intellectronica) on 2008-04-21

Changed in malone:
assignee:	nobody → intellectronica
importance:	Undecided → High
milestone:	none → 1.2.4

Revision history for this message

Christian Reis (kiko) wrote on 2008-04-21:

Incidentally, this affects the queue page when trying to approve a package which fixes the above bug.

Eleanor Berger (intellectronica) on 2008-04-22

Changed in malone:
status:	New → In Progress

Revision history for this message

Eleanor Berger (intellectronica) wrote on 2008-04-22:

RF 6141

Changed in malone:
status:	In Progress → Fix Committed

Eleanor Berger (intellectronica) on 2008-05-06

Changed in malone:
status:	Fix Committed → Fix Released

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

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