Insert bug notification recipients records in a single SQL statement

Bug #358592 reported by Eleanor Berger
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Eleanor Berger

Bug Description

Currently, new activity that requires notifications to be sent, triggers and iteration over all recipients that issues an INSERT statement for every recipient. This results in timeouts processing actions. We can optimize this by collecting all recipients and insert the records for them in a single SQL statement.

OOPS-1195ED139

Changed in malone:
assignee: nobody → Tom Berger (intellectronica)
importance: Undecided → High
milestone: none → 2.2.4
status: New → Triaged
Changed in malone:
status: Triaged → In Progress
description: updated
tags: added: oops timeout
Revision history for this message
Björn Tillenius (bjornt) wrote : Bug fixed by a commit

Fixed in devel r8202.

Changed in malone:
status: In Progress → Fix Committed
Changed in malone:
status: Fix Committed → Fix Released
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.