4 ms·
Latency-wise maybe, but throughput can be more important for a lot of applications or bigger databases. I say "maybe" because even there, SQLite is much more l
by remram 4y ago
Latency-wise maybe, but throughput can be more important for a lot of applications or bigger databases.
I say "maybe" because even there, SQLite is much more limited in terms of query-planning (very simple statistics) and the use of multiple indexes.
That's assuming we're talking about reads, PostgreSQL will win for write-heavy workloads.