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 very small. Reading pages from the OS's file cache has more overhead than fetching them from SQLite's internal page cache, so the answer is "it depends". You have to try it out with both settings. Regards, Clemens
