5 ms·
If you need HA then SQLite is out of the question, but query latency is usually lower than for MySQL/Postgres - with an embedded DB you are avoiding network lat
by citrin_ru 6y ago
If you need HA then SQLite is out of the question, but query latency is usually lower than for MySQL/Postgres - with an embedded DB you are avoiding network latency. See also https://sqlite.org/np1queryprob.html https://sqlite.org/np1queryprob.html
- avinassh 6y agowhat would be the tail latency when 1000s of requests waiting to write?
- saberience 6y agoHow can you have an embedded database if you have tens or hundreds of application servers which all need to be able to access the same dataset?
- citrin_ru 6y agoOf course it is not a good fit for SQLite. I was pointing out only that its latency is not bad (at least for for read mostly workload). There is common misconception that SQLite is OK only if the load is very low (<1rps), but in practice you can use SQLite for much higher load if you app stays within one host.