* More indices.

Dependencies

• [2] 6QRHXIM3 * Speed up the jobset index page. Especially the query to get the
• [3] RAKTHYAI * In the job status and error pages, show when the status of a job
• [4] KN3VYE5P * Cleaned up the foreign key constraints.
• [*] N22GPKYT * Put info about logs / build products in the DB.

Change contents

• edit in src/sql/hydra.sql at line 432
  [2.2524]

  [2.2524]
  + create index IndexBuildStepsOnDrvpathTypeBusyStatus on BuildSteps(drvpath, type, busy, status);

  + create index IndexBuildStepsOnOutpath on BuildSteps(outpath);
• replacement in src/sql/hydra.sql at line 442
  [2.3040]→[2.3040:3114](∅→∅)
  − create index IndexJobsetAltsOnJobset on JobsetInputAlts(project, jobset);
  [2.3040]

  [3.8636]
  + create index IndexCachedGitInputsOnHash on CachedGitInputs(uri, branch, sha256hash);

  + create index IndexCachedGitInputsOnLastSeen on CachedGitInputs(uri, branch, lastSeen);

  + create index IndexCachedSubversionInputsOnUriRevision on CachedSubversionInputs(uri, revision);

  + create index IndexJobsetInputAltsOnInput on JobsetInputAlts(project, jobset, input);

  + create index IndexJobsetInputAltsOnJobset on JobsetInputAlts(project, jobset);

  + create index IndexProjectsOnEnabled on Projects(enabled);