SQLite Forum

Sqlite high IO load makes usage impossable
Login
Yeah, we need the latter one, this is effectively a web app with many random reads going on at the same time.

When we tried to mutex the reads and write connections, there was already so much entanglement and difficulty getting all continuous `SELECT`s to stop (as some iterate over values, and then begin a new special/informed `SELECT` iteration from that value individually)

So in this case we would indeed need both.