PersonSubscriptionsView.subscribedBugTasks() will be very inefficient for users with lots of subscriptions

Bug #656904 reported by Gavin Panella
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Triaged
High
Unassigned

Bug Description

There are two problems:

- It iterates through every single bugtask to which the user is
  subscribed,

- For each bugtask it calls bugtask.bug.default_bugtask, which
  executes a database query (or two, if the bug is not already
  prejoined).

These problems can probably be addressed with careful use of a
slice-aware pre_iter_hook in DecoratedResultSet.

Gavin Panella (allenap)
tags: added: tech-debt
description: updated
Gavin Panella (allenap)
Changed in malone:
milestone: 10.10 → none
tags: added: performance
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.