diff options
| author | stephan <stephan@noemail.net> | 2022-12-02 08:51:22 +0000 |
|---|---|---|
| committer | stephan <stephan@noemail.net> | 2022-12-02 08:51:22 +0000 |
| commit | 1078ee095980c97d7c873fca488470e43ed56797 (patch) | |
| tree | 66dcd0eb249432bcd8f3c9bde66596bb0d310b9e /ext/wasm/api/sqlite3-wasm.c | |
| parent | 20f0128acc16b44519933d0ab6ff9373b647227f (diff) | |
| download | sqlite-1078ee095980c97d7c873fca488470e43ed56797.tar.gz sqlite-1078ee095980c97d7c873fca488470e43ed56797.zip | |
Correct the problem which triggered the rollback in [7eec635562f6]: an incorrect default db page size (not a multiple of 512 bytes).
FossilOrigin-Name: e06e490c240aa56b616e6f0380b5d08abf06f35f9e683e5150c5ac464eae9e55
Diffstat (limited to 'ext/wasm/api/sqlite3-wasm.c')
| -rw-r--r-- | ext/wasm/api/sqlite3-wasm.c | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/ext/wasm/api/sqlite3-wasm.c b/ext/wasm/api/sqlite3-wasm.c index 0e8aabd1a..9acc8020e 100644 --- a/ext/wasm/api/sqlite3-wasm.c +++ b/ext/wasm/api/sqlite3-wasm.c @@ -66,12 +66,15 @@ #endif #if !defined(SQLITE_DEFAULT_PAGE_SIZE) /* -** OPFS performance is improved with a page size of 8kb instead of -** 4kb. Performance with 16kb is equivalent to 8kb. +** OPFS performance is improved by approx. 12% with a page size of 8kb +** instead of 4kb. Performance with 16kb is equivalent to 8kb. ** -** However... kvvfs doesn't work at all with 8kb! +** Performance difference of kvvfs with a page size of 8kb compared to +** 4kb, as measured by speedtest1 --size 4, is indeterminate: +** measurements are all over the place either way and not +** significantly different. */ -# define SQLITE_DEFAULT_PAGE_SIZE 4096 /* 8196 */ +# define SQLITE_DEFAULT_PAGE_SIZE 8192 #endif #ifndef SQLITE_DEFAULT_UNIX_VFS # define SQLITE_DEFAULT_UNIX_VFS "unix-none" |