From 1078ee095980c97d7c873fca488470e43ed56797 Mon Sep 17 00:00:00 2001 From: stephan Date: Fri, 2 Dec 2022 08:51:22 +0000 Subject: Correct the problem which triggered the rollback in [7eec635562f6]: an incorrect default db page size (not a multiple of 512 bytes). FossilOrigin-Name: e06e490c240aa56b616e6f0380b5d08abf06f35f9e683e5150c5ac464eae9e55 --- ext/wasm/api/sqlite3-wasm.c | 11 +++++++---- 1 file changed, 7 insertions(+), 4 deletions(-) (limited to 'ext/wasm/api/sqlite3-wasm.c') 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" -- cgit v1.2.3