Re: [sqlite] how to put the database in cache without waiting the system do it by himself ?

On Fri, Jan 14, 2011 at 1:18 PM, Vander Clock Stephane < svandercl...@yahoo.fr> wrote: > it's not enalf :( > > > Read the file! > > > If you know your queries in advance and it's some SELECT you can create a temporary query wrapped into "SELECT COUNT(*) FROM (your select here)" and execute it whe

Re: [sqlite] how to put the database in cache without waiting the system do it by himself ?

it's not enalf :( On 1/14/2011 1:48 AM, Jean-Christophe Deschamps wrote: >> 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 t

Re: [sqlite] how to put the database in cache without waiting the system do it by himself ?

> 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

Re: [sqlite] how to put the database in cache without waiting the system do it by himself ?

>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 fast

[sqlite] how to put the database in cache without waiting the system do it by himself ?

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 fa