Person:+specworkload timeouts

[Robert Collins]

  4 SELECT $INT FROM (SELECT Specification.approver, Specification.assignee, Specification.completer, ... tion_status = $INT AND Specification.definition_status = $INT) ) LIMIT $INT) AS "_tmp" LIMIT $INT:
   GET: 4 Robots: 4 Local: 0
      2 https://blueprints.launchpad.net/%7Elocoteams/+specworkload (Person:+specworkload)
       OOPS-1900H932, OOPS-1900K59
      1 https://blueprints.launchpad.net/%7Elaunchpad-beta-testers/+specworkload (Person:+specworkload)
       OOPS-1900J432
      1 https://blueprints.launchpad.net/%7Eloco-philippine-team/+specworkload (Person:+specworkload)
       OOPS-1900B479

death by sql
1 94 9389 99 9290 SQL-launchpad-main-slave
SELECT $INT
FROM
  (SELECT Specification.approver, Specification.assignee, Specification.completer, Specification.date_completed, Specification.date_goal_decided, Specification.date_goal_proposed, Specification.date_started, Specification.datecreated, Specification.definition_status, Specification.direction_approved, Specification.distribution, Specification.distroseries, Specification.drafter, Specification.goal_decider, Specification.goal_proposer, Specification.goalstatus, Specification.id, Specification.implementation_status, Specification.man_days, Specification.milestone, Specification.name, Specification.OWNER, Specification.priority, Specification.private, Specification.product, Specification.productseries, Specification.specurl, Specification.starter, Specification.summary, Specification.superseded_by, Specification.title, Specification.whiteboard
   FROM Specification
   WHERE ($INT=$INT
          OR Specification.OWNER = $INT
          OR Specification.assignee = $INT
          OR Specification.drafter = $INT
          OR Specification.approver = $INT
          OR Specification.id IN
            (SELECT specification
             FROM SpecificationSubscription
             WHERE person = $INT)
          OR Specification.id IN
            (SELECT specification
             FROM SpecificationFeedback
             WHERE reviewer = $INT))
     AND (Specification.product IS NULL
          OR Specification.product NOT IN
            (SELECT Product.id
             FROM Product
             WHERE Product.active IS FALSE))
     AND NOT (Specification.implementation_status = $INT
              OR Specification.definition_status IN ($INT, $INT)
              OR (Specification.implementation_status = $INT
                  AND Specification.definition_status = $INT))LIMIT $INT) AS "_tmp" LIMIT $INT

[William Grant (wgrant)]

For each member in the batch, it a separate query to determine if there are any specs to show. If there are, it does another query to fetch them. Should be a pretty simple preloading case.