Launchpad itself

  1. Bug #652802
  2. Comment #1

Comment 1 for bug 652802

Revision history for this message
Stuart Bishop (stub) wrote :

# select count(*) from bugnotificationrecipientarchive where person=6213;
-[ RECORD 1 ]-
count | 112647

# select count(*) from bugnotificationrecipientarchive where person=754157;
-[ RECORD 1 ]
count | 24856

# select count(*) from bugnotificationrecipientarchive;
-[ RECORD 1 ]---
count | 58548792

I'd say it is slow because it is trying to update a huge number of rows. Like person merge, this is going to have to be done asynchronously.