Adding indexes on reporting and run_fields is likely to improve the performance of queries on the YathUI database, especially those looking back on data for a large number of runs in a window.
Specifically,
CREATE INDEX reporting_run_analytics
ON reporting (run_id, test_file_id, subtest, pass, fail, duration);
CREATE INDEX run_fields_name ON run_fields (name);
Adding indexes on
reportingandrun_fieldsis likely to improve the performance of queries on the YathUI database, especially those looking back on data for a large number of runs in a window.Specifically,