4 ms·
How does it handle infinite reads? For example: I used to work with a Couchbase cluster of 6 nodes, billions of documents (> 1TB of data) and doing roughly 25k
by saberience 6y ago
How does it handle infinite reads?
For example: I used to work with a Couchbase cluster of 6 nodes, billions of documents (> 1TB of data) and doing roughly 25k-50k reads per second and every read was returned in < 1ms.
Are you telling me we could have used SQLite on a single instance and it would have also have an average end to end latency of < 1ms. I.e. from App server to DB and back was < 1ms? For 25k+ OPS/sec?
- slver 6y agoObviously a tiny embedded library that reads off a file on disk won't replace a "Couchbase cluster of 6 nodes etc. etc." But SQLite has no hard limits on number of readers. There are no sockets, or Unix pipes. It reads off file cache in RAM, or if your data is bigger, it reads of disk. Like you would from a file. How'd you answer how many reads you can do from RAM? Kind of... depends on everything else, doesn't it? I'd say it can have comparable performance to a single MySQL instance for simple read queries. If that helps.
- yread 6y ago50k reads per second? And you need how many servers for that? Sqlite can't do infinite reads but pretty close https://blog.expensify.com/2018/01/08/scaling-sqlite-to-4m-qps-on-a-single-server/ https://blog.expensify.com/2018/01/08/scaling-sqlite-to-4m-q...