Jamie wrote: > this is not the normal Windows File Caching that you would typically > see. File Caching would be under STANDBY Mapped File
To rule out SQLite's mmap, execute "PRAGMA mmap_size = 0", and then confirm with the output of "PRAGMA mmap_size". <https://msdn.microsoft.com/en-us/library/windows/hardware/dn567645.aspx> says that there is a different kind of file cache for a random-access file, and that it shows up as active mapped pages. SQLite does not use FILE_FLAG_RANDOM_ACCESS (except on Windows CE), but it's possible that Windows is estimating that the accesses are random (because the actually are). Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
