> so i guess it's because the windows cache in memory the database file ?
If you launch your application again then yes it's OS disk cache. If you execute same query later in your application without stopping it and maybe even without closing connection to SQLite database then it could be SQLite's page cache. You can't fill it in any other way than executing queries. Pavel On Thu, Jan 13, 2011 at 4:55 PM, Vander Clock Stephane <svandercl...@yahoo.fr> wrote: > hello, > > when i just launch th application, at the beginning the query can take > around fews seconds... but after some time (10 - 20 minutes), it's take > only few ms ! > > so i guess it's because the windows cache in memory the database file ? > > so how to speed up this time to make windows cache more fastly in memory > the database file ? > > thanks you by advance > stephane > _______________________________________________ > 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
