4 ms·
It is even a little better than that these days. Beginning a transaction normally locks the whole database, but with Wal mode they have added a Begin Concurren
by stonemetal12 4y ago
It is even a little better than that these days. Beginning a transaction normally locks the whole database, but with Wal mode they have added a Begin Concurrent command so there can be multiple transactions going at once. However when you get to the commit it still requires the exclusive lock. I bet after a few years even that restriction will be gone.
https://www.sqlite.org/cgi/src/doc/begin-concurrent/doc/begin_concurrent.md https://www.sqlite.org/cgi/src/doc/begin-concurrent/doc/begi...
- SPBS 4y agohttps://sqlite.org/forum/info/2ad28cb1e0356816e7b0bd2ab458f75daff18e0b346220769febf541dc90e0ef https://sqlite.org/forum/info/2ad28cb1e0356816e7b0bd2ab458f7... I don't think BEGIN CONCURRENT is out yet. AFAIK it's only available if you build the experimental wal2 branch yourself.
- stonemetal12 4y agoI guess I miss read the branch list, I thought the begin-concurrent-3.39 branch said it had merged to trunk but that is the line above it.