Thanks Max! that works great!
Thank you all for your answers. I learned a lot about cache today :)
> From: slav...@bigfraud.org
> Date: Thu, 30 Dec 2010 06:14:50 +0000
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] clear cache for performance measure
>
>
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
