9 ms·
"If it's write heavy, and you need to use transactions for writes, you're screwed either way. (i.e. don't use sqlite)" That depends on your definition of "writ
by simonw 2y ago
"If it's write heavy, and you need to use transactions for writes, you're screwed either way. (i.e. don't use sqlite)"
That depends on your definition of "write heavy". Given SQLite's performance I would expect anything below 1,000 writes a second to work just fine even with write locks, given moderately capable hardware.