4 ms·
The whole job of sqlite is to handle the locking to keep such accesses safe.
by sneak 6y ago
The whole job of sqlite is to handle the locking to keep such accesses safe.
- nawgszy 6y agoOk, I see. I did some reading and it looks like this to me: * the DB is supported by a backing file * this backing file supports multiple read threads simultaneously but writes are locked via filesystem locks * write performance with multiple writers is therefore dangerous * read performance is good if no one is writing and consistent even if someone is