grahamc/hydra2 - Change 2JGYLIEC6A4HU6Y4FVMBMAKV4YF2ZNJPVNZGCS4AWDTQW5BWBHXQC

Speed up the listing of jobset evals by caching some info in the DB

This denormalises the database, but it's the best we can do until PostgreSQL has materialised views.

Created by Eelco Dolstra on April 15, 2012

2JGYLIEC6A4HU6Y4FVMBMAKV4YF2ZNJPVNZGCS4AWDTQW5BWBHXQC

Dependencies

[2] D5QIOJGPKQJIYBUCSC3MFJ3TXLPNZ2XMI37GXMFRVRFWWR2VMTFAC

In channels

main

Change contents

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

[2.3004]

alter table JobsetEvals
    add column nrBuilds integer,
    add column nrSucceeded integer;
update JobsetEvals e set
    nrBuilds = (select count(*) from JobsetEvalMembers m where e.id = m.eval)
    where hasNewBuilds = 1;