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

2011-01-14 Thread Max Vlasov 
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 when the program starts. In this case you don't have to save this
temporary result (it's a single row and single column) and the system and
sqlite will read the same parts of the file that will be needed later.

Max Vlasov
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2011-01-14 Thread Vander Clock Stephane 
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 the database file ?
>>
>> so how to speed up this time to make windows cache more fastly in memory
>> the database file ?
> Read the file!
>
> ___
> 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

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

2011-01-13 Thread Pavel Ivanov 
> 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
 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

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

2011-01-13 Thread Jean-Christophe Deschamps 

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

Read the file!

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2011-01-13 Thread Vander Clock Stephane 
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