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. I discovered this and share in this post: http://www.mail-archive.com/sqlite-users@sqlite.org/msg54234.html and successfully used it since then. Implementing this flag in sqlite would be too platform-specific so in my admin I did a checking menu that forces the admin to "touch" the file with brief file opening with this flag before open (reopen), works flawlessly and helped me to compare many queries just like in your task Max Vlasov _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
