4 ms·
This design does not handle hot partitions well and they are ubiquitous to so many domains.
by kikimora 2y ago
This design does not handle hot partitions well and they are ubiquitous to so many domains.
- simonw 2y agoYour partition would have to be VERY hot for SQLite not to be able to handle it - anything up to several thousand writes per second would likely work fine. Since this is all running on Cloudflare you could scale reads with a 1 second cache TTL somewhere, which would drop your incoming read queries to around one per second no matter how much read traffic you had.