[agmartin]

SQLite can't be tuned for performance? That's news to me. I was pretty sure that you can do that.

[jbaiter]

Absolutely. Turning on Write-Ahead Logging, disabling synchronous writes and putting temporary tables in memory can help tremendously, especially in situations where there are lots of concurrent read/writes.