3 ms·
It depends on the usage patterns of your site. If it's write heavy, and you need to use transactions for writes, you're screwed either way. (i.e. don't use sql
by hnfong 2y ago
It depends on the usage patterns of your site.
If it's write heavy, and you need to use transactions for writes, you're screwed either way. (i.e. don't use sqlite)
If it's not write heavy, but you enabled `ATOMIC_REQUESTS = True` then all your requests will be serialized (which is obviously bad)
If your site does not write often and your reads don't require transactions, using BEGIN IMMEDIATE TRANSACTION is probably fine. Your transactional writes will still be serialized but if they don't happen often it's probably fine for a low/medium-low traffic site.
- 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.