en Copyright 2015 Java http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#da264159 Rework automatically acquired OPFS locks to be released during idle time. This eliminates the performance hit reported in [46304ba057707c].FossilOrigin-Name: a7fe91afca473fe55c983bc81d214df4ef3699863c7423fa4b6b9cde23d6a3b4 List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Thu, 10 Nov 2022 13:14:30 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#8948fbee Move the sqlite3.capi.wasm namespace to sqlite3.wasm. This causes a tiny bit of naming confusion with the sqlite3.wasm *file*, but seems to make more sense than having it as a sub-namespace of capi.FossilOrigin-Name: 3f16eb18d6186ca972fca952ccac18649e7a905213f589e53c0c9333e695448d List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Sat, 29 Oct 2022 07:54:10 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#cd0df83c Apply considerable acrobatics to get the JS/WASM deliverables building to and loadable from a directory other than the one which contains the app-level code. Requires an only-slightly-leaky abstraction of passing a URL argument when loading sqlite3.js but provides much greater flexibility in where the JS/WASM files are located.FossilOrigin-Name: 6d468dab9eb84d4548f68014959f02fe4f66455472ff24fe729382bb2972e3d1 List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Wed, 19 Oct 2022 04:44:58 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#f6b6188b Update the 'start in speedtest kvvfs' link in speedtest1-worker to account for recent changes.FossilOrigin-Name: f4d5ba412e0c1a031430a32c9ed1e11a09af33f9883150e660cc05e49fe56e6a List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Tue, 04 Oct 2022 08:58:22 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#d234902b Add configurable cache_size to batch-runner and speedtest1-worker. Add SQL tracing to demo-123.js just for demonstration's sake.FossilOrigin-Name: 2ab065133bec19f71a1dc382946fdbd020920b2e38a526f4126a3a1e8df5de87 List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Mon, 03 Oct 2022 18:07:25 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#33ded6ed Add journal=MODE to the list of supported URL flags for speedtest1-worker.html.FossilOrigin-Name: 5c43e8d2ec23f28fdce63874d9d4c8ccbb4a8f81030b19d65ff5711a7c32697e List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Mon, 03 Oct 2022 11:23:47 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#3d645484 wasm/js: rename /persistent to /opfs to account for potential future persistent storage options. Minor flag-handling cleanups in the speedtest1 pages. Minor API tweaks in oo1.FossilOrigin-Name: 4dc972a3656b2a9ec915bfb3f653136560c753ce4024c3f0d0d0c28f66db7a0a List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Tue, 27 Sep 2022 09:17:37 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#e8afca3f Correct mistyped --shrink-memory flag in speedtest1-worker. Minor OPFS proxy cleanups.FossilOrigin-Name: 86e2b55ec9483fa5add51a479c6509d73461f1ac6fca5d49e057b1c66f4314d2 List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Wed, 21 Sep 2022 14:02:47 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#5e8bb0aa An alternative messaging strategy for the OPFS VFS proxy which uses only SharedArrayBuffer and Atomics, instead of worker messages, for communication (only the initial one-time handshake during initialization uses worker messages). It runs speedtest1 approx. 15-20% faster but still 20-ish% slower than WASMFS.FossilOrigin-Name: a83ee3082d89439ea3ad5737e63e25bebb0f91895aca006ce5fecf5b93a2651a List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Tue, 20 Sep 2022 08:27:57 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#f815011a Cut the speedtest1 runtime of the OPFS VFS proxy by approximately 3/4ths via xRead/xWrite buffer-copying optimizations. Still slower than the WASMFS impl by approx. 1/5th.FossilOrigin-Name: fb7f287310d74a3e236125ae9c49b859f9263c29ae85161c1bcf9dd0778d8a51 List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Mon, 19 Sep 2022 17:09:09 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#61418d5a Remove an obsolete file. Update wasmfs build for today's changes. Fix the case that OPFS.xTruncate() is passed a BigInt instead of a Number.FossilOrigin-Name: 976053925013bf1975f5f9222e28ba648af28e305bb6bdae600eb24d0e136bec List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Mon, 19 Sep 2022 14:56:13 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#0e0687cc Add sqlite3_web_vfs_list() to JS API. Corrected OPFS VFS's registering itself as the default VFS. speedtest1-worker now uses the xDelete() of both the default VFS and OPFS, to avoid that it starts up with a persistent OPFS test db (the native app calls unlink(), but that unlink call operates on a different virtual filesystem than the OPFS VFS).FossilOrigin-Name: 2ec7e09139a510b9fd29e4c97283b20740a00f369193c6fecbb734f187e81b48 List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Mon, 19 Sep 2022 13:44:23 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#b5ae85ec Merge kv-vfs branch into fiddle-opfs. Adjust various JS APIs and apps to deal with the new method of handling kvvfs. Adjust speedtest1 JS build to include sqlite3-api.js so that it can use kvvfs and opfs VFSes. Permit passing of the vfs as a URL parameter to certain demo/test apps. Milestone: speedtest-worker.html?vfs=opfs runs with the standalone OPFS impl.FossilOrigin-Name: ec09f32f7ae2249aaf27388ad2062982afa8bbbb5f88d236d6d9068bf33ad93d List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Mon, 19 Sep 2022 13:16:35 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#0144a848 Add return value checks to kvstorageWrite(), necessary for recognizing storage-full errors in the JS binding. speedtest1-kvvfs.html runs successfully on localStorage with --size 1 to 6 and starts failing with storage shortage at --size 7.FossilOrigin-Name: 13839759f8f45e4eb0aa6a5052801f3964d5b2dc2e427e5e91ee6692176381eb List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Fri, 16 Sep 2022 01:05:19 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#28ef9bdd More work on the synchronous OPFS experimentation. Numerous wasm/js build tweaks. Add speeedtest-wasmfs.html, the wasmfs/opfs counterpart of speedtest1.html.FossilOrigin-Name: 00ee49a3a2c148480f614e49a0ee5b35a255758c0a53693f0b464b31e7a4045b List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Thu, 15 Sep 2022 06:42:41 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#f5bf66c8 Remove a reference to a completed TODO.FossilOrigin-Name: 757ad69607201a26802a304839b8454b1634712458539d6aa8cf999ab2447e59 List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Fri, 09 Sep 2022 05:39:36 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#e66b2681 speedtest1 wasm: add a link in the worker variant which launches the main-thread variant with the selected CLI flags. Append collected stdout/stderr to the main-thread page after execution is finished to avoid having to open the dev tools (which inexplicably slows down wasm execution).FossilOrigin-Name: 02709ee2beab36d144b807fd9ffaee639e3c1bdd1908a34e05f3fd23dad2ef66 List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Fri, 09 Sep 2022 04:50:18 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#dd628ed5 Make use of the --big-transactions flag in the speedtest1 JS apps.FossilOrigin-Name: f2846dcbcaac7880394fb14597c3a60ed310419128c4c5b863cd771a7e5cdeb5 List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Thu, 08 Sep 2022 21:33:50 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#1174c23e Minor build cleanups and tweaks in the speedtest1 wasm apps.FossilOrigin-Name: 5240fb4d795dea826f23cf5d2152b519f5a46f49bb2499ea868fa7c7f4ce788b List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Thu, 08 Sep 2022 20:04:52 +0000 stephan <stephan@noemail.net> http://172.16.0.5:8080/history/sqlite-3.40.0/ext/wasm/speedtest1-worker.html#44a87f08 Add speedtest1-worker.html, an interactive Worker-thread variant of speedtest1.html. Add ext/wasm/index.html to act as a gateway to the various test pages.FossilOrigin-Name: f16c68ee6d5ebb8dec2ab656dbab2ddb5f1d5133153ad553f986b31020adaa38 List of files: /sqlite-3.40.0/ext/wasm/speedtest1-worker.html Thu, 08 Sep 2022 15:30:59 +0000 stephan <stephan@noemail.net>