Working with a Very Large Database

[EvanPiro]

I'm using sqlite-simple to work with a very large database. The database has one logging table with a high throughput (10+ logs a second). I've tuned the db to use WAL and upped busy_timeout but I'm now reach an issue with basic SELECT statements to small tables hanging in pending for over a few seconds from handlers in my API. Are there any techniques for hunting down the cause of this read contention? I'm using servant and sharing a connection across the read endpoints.

[jchia]

Is this a question about sqlite3 or sqlite-simple? Does the hanging problem happen when you query by hand without using sqlite-simple?