Comment 11 for bug 741092

Wheeee

Branch: launchpad-rev-12696
Revno: 12696
SQL time: 664 ms
Non-sql time: 24942 ms
Total time: 25606 ms
Statement Count: 29

6 seconds between
26. 159 58ms SQL-launchpad-main-slave
SELECT ArchiveSubscriber.archive,
       ArchiveSubscriber.cancelled_by,
       ArchiveSubscriber.date_cancelled,
       ArchiveSubscriber.date_created,
       ArchiveSubscriber.date_expires,
       ArchiveSubscriber.description,
       ArchiveSubscriber.id,
       ArchiveSubscriber.registrant,
       ArchiveSubscriber.status,
       ArchiveSubscriber.subscriber
FROM ArchiveSubscriber
WHERE ArchiveSubscriber.archive = 21283
  AND ArchiveSubscriber.status = 1
ORDER BY ArchiveSubscriber.date_created DESC

and

27. 6731 574ms SQL-launchpad-main-slave
SELECT Person.account,

and then 16 seconds before it runs up against a valid person cache check and fails spectacularly.

Clearly the SQL is fast enough; possibly canonical_url or some other formatter inefficiency.