Person:+archivesubscriptions timeouts (late evaluation)

[Cody A.W. Somerville]

https://launchpad.net/%7Ereprepro/+archivesubscriptions

OOPS-1950CQ433

The culprit is 7 seconds running repeated 100ms queries. Making the queries 20% faster or more (or doing one query thats slightly slower but not repeated) should solve this.

4 61 6994 114 6880 SQL-launchpad-main-master
SELECT $INT
FROM
  (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.subscriber IN
       (SELECT TeamParticipation.team
        FROM ArchiveSubscriber, TeamParticipation
        WHERE TeamParticipation.person = $INT
          AND TeamParticipation.team = ArchiveSubscriber.subscriber)
     AND ArchiveSubscriber.archive = $INT
     AND ArchiveSubscriber.status = $INTLIMIT $INT) AS "_tmp" LIMIT $INT

[Launchpad QA Bot (lpqabot)]

Fixed in stable r12998 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/12998>.