4 ms·
WAL mode means readers do not block writers and a writer does not block readers. If it locked the entire database you likely weren’t using WAL.
by lvh 7y ago
WAL mode means readers do not block writers and a writer does not block readers. If it locked the entire database you likely weren’t using WAL.
- GordonS 7y agoI was definitely using WAL - I know I mentioned using reader/write locks, but that was so the C# locking mechanism worked the way I wanted; I realise that SQLite doesn't block readers on writes. My point, not well made :), was that a lightweight locking mechanism worked much faster than SQLite's file-based locking mechanism. This was on Windows, mind, so things might be very different on Linux.