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

[?]
Apr 15, 2012, 10:46 PM
2JGYLIEC6A4HU6Y4FVMBMAKV4YF2ZNJPVNZGCS4AWDTQW5BWBHXQC

Dependencies

  • [2] D5QIOJGP * Move everything up one directory.

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;