3 ms·
Is there a significant advantage of the sqlite in-memory page cache over the page cache that's already included with the operating system?
by bootsmann 1y ago
Is there a significant advantage of the sqlite in-memory page cache over the page cache that's already included with the operating system?
- jitl 1y agoYes: SQLite needs to inspect the schema when it opens a new connection object and does some O(number of conns) lookups in global state during this process. It’s best to avoid re-doing this work.