3 ms·

Thanks! Yeah, I guess on the web it would always manifest as load time. But order of magnitude, with everything cached, on a decent laptop/desktop, is it a few

by ncruces 5mo ago

Thanks! Yeah, I guess on the web it would always manifest as load time. But order of magnitude, with everything cached, on a decent laptop/desktop, is it a few seconds, or a minute? Because what I get from testing in CI is every test takes a minute.

quirissum 5mo ago
With everything cached in production (compressed) it takes ~100ms to load the binary. Total global initialization including Go runtime startup and SQLite connection takes ~280ms on an M1 MacBook Pro. So well under a second end to end with a warm cache.
- ncruces 5mo ago
  That's good to know, thanks! It makes this quite realistic, which might mean a good/great OPFS VFS (like Roy's) actually starts to make sense. https://github.com/rhashimoto/wa-sqlite/discussions https://github.com/rhashimoto/wa-sqlite/discussions Unfortunately I'm not knowledgeable enough on the browser side of things to advance something like that, and have quite a bit on my plate already. But if there's interest I can help demystify the SQLite/VFS side of things. Feel free to (e.g.) open a GitHub discussion on my repo to track this.