* Speed up the jobstatus query a little bit.

Dependencies

• [2] Z4KRJX4Q * In the last succeeded / job status queries, use the Builds.isCurrent
• [3] OZ5UBJEK
• [4] SZYY2EQQ * Make the queries more readable.
• [5] ZI535LI6 * hydra: 'new' UI for project/jobset/job/build
• [*] J5UVLXOK * Start of a basic Catalyst web interface.

Change contents

• replacement in src/lib/Hydra/Schema/Builds.pm at line 274
  [3.877]→[3.877:941](∅→∅)
  − (select project, jobset, job, system, max(id) as id
  [3.877]

  [2.733]
  + (select

  + (select max(id) from builds b

  + where

  + project = activeJobs.project and jobset = activeJobs.jobset

  + and job = activeJobs.job and system = activeJobs.system

  + and finished = 1

  + ) as id
• replacement in src/lib/Hydra/Schema/Builds.pm at line 282
  [2.777]→[2.777:894](∅→∅),[2.894]→[3.1036:1090](∅→∅),[3.1036]→[3.1036:1090](∅→∅)
  − natural join Builds

  − where finished = 1

  − group by project, jobset, job, system)

  − as latest

  − natural join Builds x
  [2.777]

  [3.1090]
  + ) as latest

  + join Builds x using (id)