6 ms·
Doesnt sqlite fail fast when many users commit at once?
by OrgNet 7y ago
Doesnt sqlite fail fast when many users commit at once?
- samatman 7y agoThere's a level of write-heaviness after which SQLite, even in WAL mode, is the wrong choice. But one can get pretty far with this design. Thousands of writes per second from a few dozen writers, no problem. Millions and hundreds, I'd use something else for that.
- Scarbutt 7y agoOr if you have 10,000 writers each taking 10ms, that's 100 WPS, not bad for most apps.