[OSSTEST PATCH 00/11] Improve performance of sg-report-host-history

Ian Jackson posted 11 patches 2 weeks ago
Failed in applying to current master (apply log)
Osstest/Executive.pm          |   2 +-
schema/runvars-host-index.sql |   8 ++
sg-report-host-history        | 152 +++++++++++++++++++---------------
3 files changed, 94 insertions(+), 68 deletions(-)
create mode 100644 schema/runvars-host-index.sql

[OSSTEST PATCH 00/11] Improve performance of sg-report-host-history

Posted by Ian Jackson 2 weeks ago
This is reasonably straightforward.

In my tests it reduces the time for an incremental run, with a hot
cache, from several hundred seconds to a handful of seconds.

This series really wants to go after the flight report improvements,
although the schema updates could be combined.

Ian Jackson (11):
  schema: Add index for quick lookup by host
  sg-report-host-history: Find flight limit by flight start date
  sg-report-host-history: Drop per-job debug etc.
  Executive: Export opendb_tests
  sg-report-host-history: Add a debug print after sorting jobs
  sg-report-host-history: Do the main query per host
  sg-report-host-history: Rerganisation: Make mainquery per-host
  sg-report-host-history: Rerganisation: Read old logs later
  sg-report-host-history: Rerganisation: Change loops
  sg-report-host-history: Drop a redundznt AND clause
  sg-report-host-history: Fork

 Osstest/Executive.pm          |   2 +-
 schema/runvars-host-index.sql |   8 ++
 sg-report-host-history        | 152 +++++++++++++++++++---------------
 3 files changed, 94 insertions(+), 68 deletions(-)
 create mode 100644 schema/runvars-host-index.sql

-- 
2.20.1