5 ms·
I don’t see how sqlite replicated to other servers can be faster than any other relational dbs replicated on those same servers, at least without taking more ch
by bsaul 4y ago
I don’t see how sqlite replicated to other servers can be faster than any other relational dbs replicated on those same servers, at least without taking more chances to loose data. The limit is most likely network latency anyway, isn’t it ?
- tptacek 4y agoOther relational databases require network roundtrips to fetch information from the database once it's replicated. SQLite doesn't. It's a huge performance difference, to the point where it changes how you access your database; for instance, there's not much point in hunting down N+1 query patterns anymore.
- bsaul 4y agohm i see. so the cost is in the initial setup of the client instance, which needs to download the whole database to its local sqlite ?