On 30 Dec 2010, at 5:16am, Max Vlasov wrote: > On Thu, Dec 30, 2010 at 3:23 AM, KimTaein <kti...@hotmail.com> wrote: > >> Thanks Simon but that PRAGMA did not work.... >> >> Eric: I am on Windows. Is there a way to force OS cache other than >> restarting the machine? >> > > Kim, there's is a trick on Windows. There's a flag FILE_FLAG_NO_BUFFERING > for file opening that not only opens a file without caching it probably > resets all existing cache for the same file
Hold on, we are now talking about different type of cache. You can clear SQLite's cache for a file by closing and reopening the file. No problem. But Windows does not cache files by individual file handle. It caches disk sectors (or pseudo-sectors), and has no idea which files the sectors belong to. So any flag on opening a file isn't going to help that. Also, the storage device itself probably caches sectors too. And that's entirely outside the control of the operating system. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
