Re: [sqlite] Reporting two more interesting queries with performance regression

2019-04-15 Thread Jinho Jung
expr.c + function: sqlite3VdbeJumpHere, sqlite3VdbeAddOp0 4) 10052.sql (third report) - bisect commit: 7153552bac - stat-dbg result: + file: expr.c + function: sqlite3VdbeJumpHere, sqlite3VdbeAddOp0 Hope this help for your further analysis. Best regards, Jinho Jung On Sat, Apr 6, 201

[sqlite] Reporting two more interesting queries with performance regression

2019-04-06 Thread Jinho Jung
ubquery number that is related back to the .selecttrace output. (user: drh tags: reuse- subqueries) Thanks for your checking and support. Best regards, Jinho Jung ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Reporting two queries with performance regression

2019-04-02 Thread Jinho Jung
- bisect fossil commit: === 2018-08-04 === [7d9072b027] Further logic simplifications that flow out of the omission of the column cache. (user: drh tags: omit-column-cache) Thanks for your support. Best regards, Jinho Jung ___ sqlite-users ma

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

2019-04-01 Thread Jinho Jung
r cases with correct bisect later. Jinho Jung On Mon, Apr 1, 2019 at 1:32 PM Richard Hipp wrote: > On 4/1/19, Jinho Jung wrote: > > Hello, > > > > We are developing a tool called sqlfuzz for automatically finding > > performance regressions in SQLite. sqlfuzz performs

[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