3 ms·
> No clue what Postgres would manage, but I suspect it would be about an order of magnitude higher latency in the happy case. Unless you’re talking 1 versus 10
by runeks 3y ago
> No clue what Postgres would manage, but I suspect it would be about an order of magnitude higher latency in the happy case.
Unless you’re talking 1 versus 10 microseconds (or less), I don’t think Postgres will have an order of magnitude higher latency. And if we are talking this range, why would it matter for a web app where the client’s latency is almost certainly >1 millisecond?
- ripley12 3y agoBecause it changes the kinds of things you can build: https://www.sqlite.org/np1queryprob.html https://www.sqlite.org/np1queryprob.html With SQLite, it's often practical to issue several queries in situations where that would be too slow for a traditional client-server database.