On 20 Oct 2019, at 1:54am, Peng Yu <pengyu...@gmail.com> wrote: > How to prove the large time difference of sqlite3 is indeed due to > cache and where is the cache?
Keep the database on an external drive (e.g. USB Flash drive). Unmount the drive to be sure that the cache has been cleared. > Why the caching used by sqlite3 can not persist for a longer time? The cache we're talking about is a file system cache, maintained by your operating system. SQLite has a cache only while it is running. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
