DB Stats: a1236d6bf92ec5cb8955f490761b21b0d3eea9d3 ======== Cmd Count TotTime Avg get-count-tests-running-for-run-id 1035 237.0 0.23 get-count-tests-running-in-jobgroup 884 119.0 0.13 get-count-tests-running 884 169.0 0.19 get-prereqs-not-met 884 732.0 0.83 get-test-info-by-id 673 122.0 0.18 get-keys 476 1.0 0.00 get-test-id 356 42.0 0.12 testmeta-get-record 203 24.0 0.12 roll-up-pass-fail-counts 159 39.0 0.25 register-test 140 30.0 0.21 test-set-rundir-shortdir 128 98.0 0.77 test-set-status-state 94 45.0 0.48 find-and-mark-incomplete 32 0.0 0.00 state-status-msg 25 4.0 0.16 delete-tests-in-state 12 4.0 0.33 get-tests-for-run-mindata 8 0.0 0.00 get-all-run-ids 5 2.0 0.40 get-run-info 4 0.0 0.00 register-run 4 5.0 1.25 set-tests-state-status 4 15.0 3.75 get-tests-for-run 4 15.0 3.75 # After converting first three functions above to sqlite3:first-result DB Stats ======== Cmd Count TotTime Avg get-count-tests-running-for-run-id 1138 179.0 0.16 get-count-tests-running-in-jobgroup 987 91.0 0.09 get-count-tests-running 987 171.0 0.17 get-prereqs-not-met 987 892.0 0.90 get-test-info-by-id 672 95.0 0.14 get-keys 476 0.0 0.00 get-test-id 355 41.0 0.12 testmeta-get-record 203 15.0 0.07 roll-up-pass-fail-counts 159 30.0 0.19 register-test 140 22.0 0.16 test-set-rundir-shortdir 128 855.0 6.68 test-set-status-state 94 20.0 0.21 find-and-mark-incomplete 36 1.0 0.03 state-status-msg 24 5.0 0.21 delete-tests-in-state 12 2.0 0.17 get-tests-for-run-mindata 9 0.0 0.00 get-all-run-ids 5 1.0 0.20 register-run 4 1.0 0.25 get-tests-for-run 4 11.0 2.75 get-run-info 4 0.0 0.00 set-tests-state-status 4 17.0 4.25 DB Stats another run, converted one or two non-relevant functions to sqlite3:first-result ======== Cmd Count TotTime Avg get-count-tests-running-for-run-id 987 157.0 0.16 get-count-tests-running-in-jobgroup 836 79.0 0.09 get-count-tests-running 836 121.0 0.14 get-prereqs-not-met 836 513.0 0.61 get-test-info-by-id 673 85.0 0.13 get-keys 476 0.0 0.00 get-test-id 356 32.0 0.09 testmeta-get-record 203 19.0 0.09 roll-up-pass-fail-counts 159 27.0 0.17 register-test 140 23.0 0.16 test-set-rundir-shortdir 128 35.0 0.27 test-set-status-state 94 20.0 0.21 find-and-mark-incomplete 40 0.0 0.00 state-status-msg 25 5.0 0.20 delete-tests-in-state 12 1.0 0.08 get-tests-for-run-mindata 10 0.0 0.00 get-all-run-ids 5 0.0 0.00 set-tests-state-status 4 15.0 3.75 register-run 4 2.0 0.50 get-run-info 4 1.0 0.25 get-tests-for-run 4 12.0 3.00