Add another index to speed up the jobstatus page

[?]
Nov 29, 2011, 5:48 PM
PT5XCF2NZMSKB3O6DNV5XNKOSXRUDTATTBMBP2FAUIREUM6X246AC

Dependencies

  • [2] C5W3WZ3Y * Index the Builds table on drvPath to prevent a full table scan
  • [3] 5L272QSC Speed up the /jobset overview pages a lot
  • [4] 2I2ZX6JB * Make the "latest succeeded" query (used by the "latest" channel)
  • [5] E2TOU3L6 * More indices.
  • [6] P5VJCT6U fix wrong comment
  • [7] 6QRHXIM3 * Speed up the jobset index page. Especially the query to get the
  • [*] N22GPKYT * Put info about logs / build products in the DB.

Change contents

  • replacement in src/sql/hydra.sql at line 535
    [4.3040][3.84:183]()
    create index IndexBuildsOnJobsetFinishedTimestamp on Builds(project, jobset, finished, timestamp);
    [4.3040]
    [4.704]
    create index IndexBuildsOnJobsetFinishedTimestamp on Builds(project, jobset, finished, timestamp DESC);
  • edit in src/sql/hydra.sql at line 537
    [4.804]
    [2.0]
    create index IndexBuildsOnJobSystemCurrent on Builds(project, jobset, job, system, isCurrent);