3 ms·
Two methods: 1. Queue up writes to a single connection in a given thread. 2. Retry the write after a short sleep when you get a SQLITE_BUSY error. SQLite will
by emadda 3y ago
Two methods:
1. Queue up writes to a single connection in a given thread.
2. Retry the write after a short sleep when you get a SQLITE_BUSY error. SQLite will do this for you, see busy_timeout docs.
WAL is single write, multiple reader, so if you are doing SELECT queries they should not return SQLITE_BUSY
- MuffinFlavored 3y agohttps://stackoverflow.com/questions/25319031/what-is-the-default-value-of-sqlite3-busy-timeout https://stackoverflow.com/questions/25319031/what-is-the-def... Just to clarify, busy_timeout = 0 by default