Improve performance of sg-report-host-history
Get series with b4
b4 am [email protected]Versions newest first
- v1 Latest11 patches 0 repliesNew
Patches in v1 No applies recorded yet
Reviews trailers per patch
No Reviewed-by, Acked-by or Tested-by trailers for v1 yet.
Cover letter [OSSTEST PATCH 00/11] Improve performance of sg-report-host-history
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
Signature · 1 line
2.20.1