3 ms·
Yes it caches pages in memory. The cache size is configurable via a PRAGMA. Postgres / MSSQL / all RDBMS is slow because of network I/O.
by nbevans 2y ago
Yes 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.