grahamc/hydra2 - Change OT4YGU4Q2ADFH372RUWU7FJCNOSKPGEBIFZQ5ZGABUSAHTDDTLCAC

Builds: index literally what latest-finished queries

Created by Graham Christensen on February 9, 2020

OT4YGU4Q2ADFH372RUWU7FJCNOSKPGEBIFZQ5ZGABUSAHTDDTLCAC

Dependencies

[2] APURLT2Q3OKS6VF4HUWI3MGENXAKSSUDXI7CQOEGCRTYJRGUNT6QC
[3] C5W3WZ3YKLMDB7P6COIHDKSKSYDGAJBSIFIHFTEKRGSEJX7J7BNAC
[4] N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC
[5] D5QIOJGPKQJIYBUCSC3MFJ3TXLPNZ2XMI37GXMFRVRFWWR2VMTFAC

In channels

main

Change contents

Insertion in src/sql/hydra.sql at line 685 [4.1]

[2.100]

[3.0]

create index IndexFinishedSuccessfulBuilds on Builds(id DESC, buildstatus, finished, job, jobset_id) where buildstatus = 0 and finished = 1;

File addition: upgrade-65.sql (----------)

[5.3004]

-- Index more exactly what the latest-finished query looks for.
create index IndexFinishedSuccessfulBuilds
  on Builds(id DESC, buildstatus, finished, job, jobset_id)
  where buildstatus = 0 and finished = 1;