2 ms·
In my experience, Sqlite is faster than Postgres etc. No latency.
by chistev 2y ago
In my experience, Sqlite is faster than Postgres etc. No latency.
- 0xDEAFBEAD 2y agoDoes sqlite cache pages in memory? If not, how can it be faster? Is it the IPC overhead of Postgres?
- nbevans 2y agoYes it caches pages in memory. The cache size is configurable via a PRAGMA. Postgres / MSSQL / all RDBMS is slow because of network I/O.
- 0xDEAFBEAD 2y ago>Postgres / MSSQL / all RDBMS is slow because of network I/O. I assume in situations where you're choosing between Postgres and sqlite, everything is running on a single machine anyways.