[sqlite] What is the best page cache size when the database is larger than system RAM?

2015-09-14 Thread Clemens Ladisch
David Barrett wrote: > If I have a database that is larger than the system's physical RAM, > am I correct in thinking I should actually set a very *small* page cache so > as to avoid "double caching" the same pages in both sqlite and the file > cache? The default setting (2048 pages) already is

[sqlite] What is the best page cache size when the database is larger than system RAM?

2015-09-14 Thread Scott Hess
On Sun, Sep 13, 2015 at 8:18 PM, David Barrett wrote: > Hello! If I have a database that is larger than the system's physical RAM, > am I correct in thinking I should actually set a very *small* page cache so > as to avoid "double caching" the same pages in both sqlite and the file > cache? > >

[sqlite] What is the best page cache size when the database is larger than system RAM?

2015-09-13 Thread David Barrett
Hello! If I have a database that is larger than the system's physical RAM, am I correct in thinking I should actually set a very *small* page cache so as to avoid "double caching" the same pages in both sqlite and the file cache? To clarify, if the database is *smaller* than system RAM, I