SQLite Forum

Sqlite high IO load makes usage impossable
Login
We are currently using sqlite 3.36.0. There are ~60 tables and the schema is the same for each of them: A blob primary key and a blob value. The database is ~30GB on my server with most of that concentrated on 2-3 tables. The key is usually < 50 bytes and the value is often a json with 500-1000 characters.

With many small requests I meant selects in the form SELECT value FROM table_name WHERE key = ?.
When not idle we probably send 500k of these selects in a short time (<1 minute). Often split among multiple threads (each thread has its own db connection).