From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on inbox.vuxu.org X-Spam-Level: X-Spam-Status: No, score=-1.0 required=5.0 tests=ALL_TRUSTED autolearn=ham autolearn_force=no version=3.4.4 Received: (qmail 10961 invoked from network); 27 Mar 2023 06:20:51 -0000 Received: from localhost (HELO inbox.vuxu.org) (::1) by localhost with ESMTPUTF8; 27 Mar 2023 06:20:51 -0000 Content-Type: multipart/mixed; boundary="===============6882389101400245148==" MIME-Version: 1.0 Subject: =?utf8?q?=5BPR_PATCH=5D_sqlite=3A_patch_performance_regression?= To: ml@inbox.vuxu.org From: classabbyamp Reply-to: ml@inbox.vuxu.org Message-ID: Date: Mon, 27 Mar 2023 08:20:47 +0200 List-Id: GitHub notification mails are now in MIME to allow UTF8. --===============6882389101400245148== Content-Type: text/plain; charset="utf8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlcmUgaXMgYSBuZXcgcHVsbCByZXF1ZXN0IGJ5IGNsYXNzYWJieWFtcCBhZ2FpbnN0IG1hc3Rl ciBvbiB0aGUgdm9pZC1wYWNrYWdlcyByZXBvc2l0b3J5CgpodHRwczovL2dpdGh1Yi5jb20vY2xh c3NhYmJ5YW1wL3ZvaWQtcGFja2FnZXMgc3FsaXRlLXBhdGNoCmh0dHBzOi8vZ2l0aHViLmNvbS92 b2lkLWxpbnV4L3ZvaWQtcGFja2FnZXMvcHVsbC80MzA0MwoKc3FsaXRlOiBwYXRjaCBwZXJmb3Jt YW5jZSByZWdyZXNzaW9uCm1vcmUgaW5mbzoKLSBodHRwczovL3NxbGl0ZS5vcmcvc3JjL2luZm8v YWE2YmQ2ZGZmNzUxMjIzZQotIGh0dHBzOi8vbG9yZS5rZXJuZWwub3JnL2Rpc3RyaWJ1dGlvbnMv ODd3bjM1Ym9kNy5mc2ZAZ2VudG9vLm9yZy9ULwoKPCEtLSBVbmNvbW1lbnQgcmVsZXZhbnQgc2Vj dGlvbnMgYW5kIGRlbGV0ZSBvcHRpb25zIHdoaWNoIGFyZSBub3QgYXBwbGljYWJsZSAtLT4KCiMj IyMgVGVzdGluZyB0aGUgY2hhbmdlcwotIEkgdGVzdGVkIHRoZSBjaGFuZ2VzIGluIHRoaXMgUFI6 ICoqTk8qKgoKCgpBIHBhdGNoIGZpbGUgZnJvbSBodHRwczovL2dpdGh1Yi5jb20vdm9pZC1saW51 eC92b2lkLXBhY2thZ2VzL3B1bGwvNDMwNDMucGF0Y2ggaXMgYXR0YWNoZWQ= --===============6882389101400245148== Content-Type: text/x-diff MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="github-pr-sqlite-patch-43043.patch" RnJvbSAzNmQ3MGM0ODhlOTFiNTk0ZWI3MTk4NWU4MWFiYjc0M2Q2ZjU4NWU2IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBjbGFzc2FiYnlhbXAgPHZvaWRAcGxhY2V2aW9sZXR0ZS5uZXQ+ CkRhdGU6IE1vbiwgMjcgTWFyIDIwMjMgMDI6MTg6NTAgLTA0MDAKU3ViamVjdDogW1BBVENIXSBz cWxpdGU6IHBhdGNoIHBlcmZvcm1hbmNlIHJlZ3Jlc3Npb24KCm1vcmUgaW5mbzoKaHR0cHM6Ly9z cWxpdGUub3JnL3NyYy9pbmZvL2FhNmJkNmRmZjc1MTIyM2UKaHR0cHM6Ly9sb3JlLmtlcm5lbC5v cmcvZGlzdHJpYnV0aW9ucy84N3duMzVib2Q3LmZzZkBnZW50b28ub3JnL1QvCi0tLQogLi4uL3Nx bGl0ZS9wYXRjaGVzLzMuNDEtcGVyZi1yZWdyZXNzaW9uLnBhdGNoIHwgMTA1ICsrKysrKysrKysr KysrKysrKwogc3JjcGtncy9zcWxpdGUvdGVtcGxhdGUgICAgICAgICAgICAgICAgICAgICAgIHwg ICAyICstCiAyIGZpbGVzIGNoYW5nZWQsIDEwNiBpbnNlcnRpb25zKCspLCAxIGRlbGV0aW9uKC0p CiBjcmVhdGUgbW9kZSAxMDA2NDQgc3JjcGtncy9zcWxpdGUvcGF0Y2hlcy8zLjQxLXBlcmYtcmVn cmVzc2lvbi5wYXRjaAoKZGlmZiAtLWdpdCBhL3NyY3BrZ3Mvc3FsaXRlL3BhdGNoZXMvMy40MS1w ZXJmLXJlZ3Jlc3Npb24ucGF0Y2ggYi9zcmNwa2dzL3NxbGl0ZS9wYXRjaGVzLzMuNDEtcGVyZi1y ZWdyZXNzaW9uLnBhdGNoCm5ldyBmaWxlIG1vZGUgMTAwNjQ0CmluZGV4IDAwMDAwMDAwMDAwMC4u MDg5NDcxNGM3MGNlCi0tLSAvZGV2L251bGwKKysrIGIvc3JjcGtncy9zcWxpdGUvcGF0Y2hlcy8z LjQxLXBlcmYtcmVncmVzc2lvbi5wYXRjaApAQCAtMCwwICsxLDEwNSBAQAorc291cmNlOiBodHRw czovL3NxbGl0ZS5vcmcvc3JjL2luZm8vYWE2YmQ2ZGZmNzUxMjIzZQorY2FuIHJlbW92ZSB3aXRo IDMuNDIuMAorCitJbmRleDogc3JjL3NlbGVjdC5jCis9PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0KKy0tLSBzcmMvc2VsZWN0 LmMKKysrKyBzcmMvc2VsZWN0LmMKK0BAIC00MjM2LDEyICs0MjM2LDExIEBACisgKiogICAgICAg ICgxN2YpIHRoZSBzdWJxdWVyeSBtdXN0IG5vdCBiZSB0aGUgUkhTIG9mIGEgTEVGVCBKT0lOLgor ICoqICAgICAgICAoMTdnKSBlaXRoZXIgdGhlIHN1YnF1ZXJ5IGlzIHRoZSBmaXJzdCBlbGVtZW50 IG9mIHRoZSBvdXRlcgorICoqICAgICAgICAgICAgICBxdWVyeSBvciB0aGVyZSBhcmUgbm8gUklH SFQgb3IgRlVMTCBKT0lOcyBpbiBhbnkgYXJtCisgKiogICAgICAgICAgICAgIG9mIHRoZSBzdWJx dWVyeS4gIChUaGlzIGlzIGEgZHVwbGljYXRlIG9mIGNvbmRpdGlvbiAoMjdiKS4pCisgKiogICAg ICAgICgxN2gpIFRoZSBjb3JyZXNwb25kaW5nIHJlc3VsdCBzZXQgZXhwcmVzc2lvbnMgaW4gYWxs IGFybXMgb2YgdGhlCistKiogICAgICAgICAgICAgIGNvbXBvdW5kIG11c3QgaGF2ZSB0aGUgc2Ft ZSBhZmZpbml0eS4gKFNlZSByZXN0cmljdGlvbiAoOSkKKy0qKiAgICAgICAgICAgICAgb24gdGhl IHB1c2gtZG93biBvcHRpbWl6YXRpb24uKQorKyoqICAgICAgICAgICAgICBjb21wb3VuZCBtdXN0 IGhhdmUgdGhlIHNhbWUgYWZmaW5pdHkuCisgKioKKyAqKiAgICAgICAgVGhlIHBhcmVudCBhbmQg c3ViLXF1ZXJ5IG1heSBjb250YWluIFdIRVJFIGNsYXVzZXMuIFN1YmplY3QgdG8KKyAqKiAgICAg ICAgcnVsZXMgKDExKSwgKDEzKSBhbmQgKDE0KSwgdGhleSBtYXkgYWxzbyBjb250YWluIE9SREVS IEJZLAorICoqICAgICAgICBMSU1JVCBhbmQgT0ZGU0VUIGNsYXVzZXMuICBUaGUgc3VicXVlcnkg Y2Fubm90IHVzZSBhbnkgY29tcG91bmQKKyAqKiAgICAgICAgb3BlcmF0b3Igb3RoZXIgdGhhbiBV TklPTiBBTEwgYmVjYXVzZSBhbGwgdGhlIG90aGVyIGNvbXBvdW5kCitAQCAtNTEwNSwxNCArNTEw NCwxMCBAQAorICoqCisgKiogICAoOCkgSWYgdGhlIHN1YnF1ZXJ5IGlzIGEgY29tcG91bmQgdGhh dCB1c2VzIFVOSU9OLCBJTlRFUlNFQ1QsCisgKiogICAgICAgb3IgRVhDRVBULCB0aGVuIGFsbCBv ZiB0aGUgcmVzdWx0IHNldCBjb2x1bW5zIGZvciBhbGwgYXJtcyBvZgorICoqICAgICAgIHRoZSBj b21wb3VuZCBtdXN0IHVzZSB0aGUgQklOQVJZIGNvbGxhdGluZyBzZXF1ZW5jZS4KKyAqKgorLSoq ICAgKDkpIElmIHRoZSBzdWJxdWVyeSBpcyBhIGNvbXBvdW5kLCB0aGVuIGFsbCBhcm1zIG9mIHRo ZSBjb21wb3VuZCBtdXN0CistKiogICAgICAgaGF2ZSB0aGUgc2FtZSBhZmZpbml0eS4gIChUaGlz IGlzIHRoZSBzYW1lIGFzIHJlc3RyaWN0aW9uICgxN2gpCistKiogICAgICAgZm9yIHF1ZXJ5IGZs YXR0ZW5pbmcuKQorLSoqICAgICAgIAorICoqCisgKiogUmV0dXJuIDAgaWYgbm8gY2hhbmdlcyBh cmUgbWFkZSBhbmQgbm9uLXplcm8gaWYgb25lIG9yIG1vcmUgV0hFUkUgY2xhdXNlCisgKiogdGVy bXMgYXJlIGR1cGxpY2F0ZWQgaW50byB0aGUgc3VicXVlcnkuCisgKi8KKyBzdGF0aWMgaW50IHB1 c2hEb3duV2hlcmVUZXJtcygKK0BAIC01MTM5LDEzICs1MTM0LDEwIEBACisgICAgICAgfQorICNp Zm5kZWYgU1FMSVRFX09NSVRfV0lORE9XRlVOQworICAgICAgIGlmKCBwU2VsLT5wV2luICkgcmV0 dXJuIDA7ICAgIC8qIHJlc3RyaWN0aW9uICg2YikgKi8KKyAjZW5kaWYKKyAgICAgfQorLSAgICBp ZiggY29tcG91bmRIYXNEaWZmZXJlbnRBZmZpbml0aWVzKHBTdWJxKSApeworLSAgICAgIHJldHVy biAwOyAgLyogcmVzdHJpY3Rpb24gKDkpICovCistICAgIH0KKyAgICAgaWYoIG5vdFVuaW9uQWxs ICl7CisgICAgICAgLyogSWYgYW55IG9mIHRoZSBjb21wb3VuZCBhcm1zIGFyZSBjb25uZWN0ZWQg dXNpbmcgVU5JT04sIElOVEVSU0VDVCwKKyAgICAgICAqKiBvciBFWENFUFQsIHRoZW4gd2UgbXVz dCBlbnN1cmUgdGhhdCBub25lIG9mIHRoZSBjb2x1bW5zIHVzZSBhCisgICAgICAgKiogbm9uLUJJ TkFSWSBjb2xsYXRpbmcgc2VxdWVuY2UuICovCisgICAgICAgZm9yKHBTZWw9cFN1YnE7IHBTZWw7 IHBTZWw9cFNlbC0+cFByaW9yKXsKKworSW5kZXg6IHRlc3QvcHVzaGRvd24udGVzdAorPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09CistLS0gdGVzdC9wdXNoZG93bi50ZXN0CisrKysgdGVzdC9wdXNoZG93bi50ZXN0CitAQCAt MTIwLDcgKzEyMCw0NyBAQAorICAgICBTRUxFQ1QgdjEuYSwgdjEuYiwgdDAuYzAgQVMgY2QgRlJP TSB0MCBMRUZUIEpPSU4gdjAgT04gdjAuYzAhPTAsIHYxCisgICApIFdIRVJFIGE9MiBBTkQgYj0w IEFORCBjZD0wOworIH0geworICAgMiAwICAgICAwCisgfQorLSAgCisrCisrIyAyMDIzLTAyLTIy IGh0dHBzOi8vc3FsaXRlLm9yZy9mb3J1bS9mb3J1bXBvc3QvYmNjNDM3NTAzMgorKyMgUGVyZm9y bWFuY2UgcmVncmVzc2lvbiBjYXVzZWQgYnkgY2hlY2staW4gWzFhZDQxODQwYzVlMGZhNzBdIGZy b20gMjAyMi0xMS0yNS4KKysjIFRoYXQgY2hlY2staW4gYWRkZWQgYSBuZXcgcmVzdHJpY3Rpb24g b24gcHVzaC1kb3duLiAgVGhlIG5ldyByZXN0cmljdGlvbiBpcworKyMgbm8gbG9uZ2VyIG5lY2Vz c2FyeSBhZnRlciBjaGVjay1pbiBbMjc2NTVjOTM1MzYyMGFhNV0gZnJvbSAyMDIyLTEyLTE0Lgor KyMKKytkb19leGVjc3FsX3Rlc3QgMy41IHsKKysgIERST1AgVEFCTEUgSUYgRVhJU1RTIHQxOwor KyAgQ1JFQVRFIFRBQkxFIHQxKGEgSU5ULCBiIElOVCwgYyBURVhULCBQUklNQVJZIEtFWShhLGIp KSBXSVRIT1VUIFJPV0lEOworKyAgSU5TRVJUIElOVE8gdDEoYSxiLGMpIFZBTFVFUworKyAgICAo MSwxMDAsJ2FiYycpLAorKyAgICAoMiwyMDAsJ2RlZicpLAorKyAgICAoMywzMDAsJ2FiYycpOwor KyAgRFJPUCBUQUJMRSBJRiBFWElTVFMgdDI7CisrICBDUkVBVEUgVEFCTEUgdDIoYSBJTlQsIGIg SU5ULCBjIFRFWFQsIFBSSU1BUlkgS0VZKGEsYikpIFdJVEhPVVQgUk9XSUQ7CisrICBJTlNFUlQg SU5UTyB0MihhLGIsYykgVkFMVUVTCisrICAgICgxLDExMCwnZWZnJyksCisrICAgICgyLDIwMCwn aGlqJyksCisrICAgICgzLDMzMCwna2xtJyk7CisrICBDUkVBVEUgVklFVyB2MyBBUworKyAgICBT RUxFQ1QgYSwgYiwgYyBGUk9NIHQxCisrICAgIFVOSU9OIEFMTAorKyAgICBTRUxFQ1QgYSwgYiwg J3h5eicgRlJPTSB0MjsKKysgIFNFTEVDVCAqIEZST00gdjMgV0hFUkUgYT0yIEFORCBiPTIwMDsK Kyt9IHsyIDIwMCBkZWYgMiAyMDAgeHl6fQorK2RvX2VxcF90ZXN0IDMuNiB7CisrICBTRUxFQ1Qg KiBGUk9NIHYzIFdIRVJFIGE9MiBBTkQgYj0yMDA7CisrfSB7CisrICBRVUVSWSBQTEFOCisrICB8 LS1DTy1ST1VUSU5FIHYzCisrICB8ICBgLS1DT01QT1VORCBRVUVSWQorKyAgfCAgICAgfC0tTEVG VC1NT1NUIFNVQlFVRVJZCisrICB8ICAgICB8ICBgLS1TRUFSQ0ggdDEgVVNJTkcgUFJJTUFSWSBL RVkgKGE9PyBBTkQgYj0/KQorKyAgfCAgICAgYC0tVU5JT04gQUxMCisrICB8ICAgICAgICBgLS1T RUFSQ0ggdDIgVVNJTkcgUFJJTUFSWSBLRVkgKGE9PyBBTkQgYj0/KQorKyAgYC0tU0NBTiB2Mwor K30KKysjICAgICAgICAgICAgICAgICAgICAgICBeXl5eXl5eXl5eXl5eXl5eXl5eXl5eXl5eXl5e Xl5eCisrIyBXZSB3YW50IGJvdGggYXJtcyBvZiB0aGUgY29tcG91bmQgc3VicXVlcnkgdG8gdXNl IHRoZQorKyMgcHJpbWFyeSBrZXkuCisrCisgZmluaXNoX3Rlc3QKKwpkaWZmIC0tZ2l0IGEvc3Jj cGtncy9zcWxpdGUvdGVtcGxhdGUgYi9zcmNwa2dzL3NxbGl0ZS90ZW1wbGF0ZQppbmRleCBkNjNj NjhmYzBmNjMuLjE0ZDAzMDU0YzllMyAxMDA2NDQKLS0tIGEvc3JjcGtncy9zcWxpdGUvdGVtcGxh dGUKKysrIGIvc3JjcGtncy9zcWxpdGUvdGVtcGxhdGUKQEAgLTEsNyArMSw3IEBACiAjIFRlbXBs YXRlIGZpbGUgZm9yICdzcWxpdGUnCiBwa2duYW1lPXNxbGl0ZQogdmVyc2lvbj0zLjQxLjIKLXJl dmlzaW9uPTEKK3JldmlzaW9uPTIKIF9hbWFsZ2FtYXRpb252ZXI9JChwcmludGYgIiVkJTAyZCUw MmQwMFxuIiAke3ZlcnNpb24vLy4vIH0pCiBidWlsZF9zdHlsZT1nbnUtY29uZmlndXJlCiBjb25m aWd1cmVfYXJncz0iLS1lbmFibGUtdGhyZWFkc2FmZSAtLWVuYWJsZS1keW5hbWljLWV4dGVuc2lv bnMgLS1lbmFibGUtZnRzNSIK --===============6882389101400245148==--