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