Re: [OSSTEST PATCH 08/14] Executive: Use index for report__find_test

2020-07-22 Thread Ian Jackson
George Dunlap writes ("Re: [OSSTEST PATCH 08/14] Executive: Use index for report__find_test"): > > On Jul 21, 2020, at 7:41 PM, Ian Jackson wrote: > > Example query before (from the Perl DBI trace): ... > So this says: > > Get me all the columns > for t

Re: [OSSTEST PATCH 08/14] Executive: Use index for report__find_test

2020-07-22 Thread George Dunlap
> On Jul 21, 2020, at 7:41 PM, Ian Jackson wrote: > > After we refactor this query then we can enable the index use. > (Both of these things together in this commit because I haven't perf > tested the version with just the refactoring.) > > (We have provided an index that can answer this quest

[OSSTEST PATCH 08/14] Executive: Use index for report__find_test

2020-07-21 Thread Ian Jackson
After we refactor this query then we can enable the index use. (Both of these things together in this commit because I haven't perf tested the version with just the refactoring.) (We have provided an index that can answer this question really quickly if a version is specified. But the query plann