4 ms·
>> when more than one process need to acces the DB > Easy, you use `journal_mode` set to `WAL` when you connect to the sqlite database. and set isolation leve
by ju-st 4y ago
>> when more than one process need to acces the DB
> Easy, you use `journal_mode` set to `WAL` when you connect to the sqlite database.
and set isolation level and check_same_thread and PRAGMA synchronous and then put all queries in retry loops because the DB is maybe locked https://sqlite.org/wal.html#sometimes_queries_return_sqlite_busy_in_wal_mode https://sqlite.org/wal.html#sometimes_queries_return_sqlite_...
I wasted so much time trying to get multiple sqlite queries running at the same time
- warmwaffles 4y ago> I wasted so much time trying to get multiple sqlite queries running at the same time You were trying to write at the same time right?
- ju-st 4y agono, although the DB was not opened readonly mode. I tested with apachebench with many parallel requests on endpoints using only SELECTs