Re: [sqlite] Need advice: Some queries show performance regression

2019-04-01 Thread Jinho Jung
Thanks for the quick response. 1) It seems our bisecting is wrong. We manually moved commit by commit by using "fossil checkout" command. Next time, we will use "fossil bisect" command. 2) Sorry for the misleading. Our first report contains three queries. We will submit another cases with correct

Re: [sqlite] Need advice: Some queries show performance regression

2019-04-01 Thread Richard Hipp
On 4/1/19, Jinho Jung wrote: > Hello, > > We are developing a tool called sqlfuzz for automatically finding > performance regressions in SQLite. sqlfuzz performs mutational fuzzing to > generate SQL queries that take more time to execute on the latest version > of SQLite compared to prior versions

[sqlite] Need advice: Some queries show performance regression

2019-04-01 Thread Jinho Jung
Hello, We are developing a tool called sqlfuzz for automatically finding performance regressions in SQLite. sqlfuzz performs mutational fuzzing to generate SQL queries that take more time to execute on the latest version of SQLite compared to prior versions. We hope that these queries would help f