4 ms·
> WAL2 + BEGIN CONCURRENT Woah. There are some gotchas. It still won't support as much concurrency as row-level MVCC. But it'll still be a big improvement.
by brandmeyer 5y ago
> WAL2 + BEGIN CONCURRENT
Woah. There are some gotchas. It still won't support as much concurrency as row-level MVCC. But it'll still be a big improvement.
https://www.sqlite.org/cgi/src/doc/wal2/doc/wal2.md https://www.sqlite.org/cgi/src/doc/wal2/doc/wal2.md
https://www.sqlite.org/src/doc/begin-concurrent/doc/begin_concurrent.md https://www.sqlite.org/src/doc/begin-concurrent/doc/begin_co...
- snovv_crash 5y agoThe amount of IO we gained in the switch from spinning rust to NVME SSDs means that a SQLite scales serialised 'concurrency' much further than eg. Postgres ever could before.