Thanks! I will do so.
JP
From: P Kishor <punk.k...@gmail.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Monday, April 20, 2009 5:18:27 PM
Subject: Re: [sqlite] what is the right cache_size for sqllite version 3.5.9
a better solution.
> JP
>
>
>
>
>
> From: Roger Binns <rog...@rogerbinns.com>
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Sent: Monday, April 20, 2009 5:11:48 PM
> Subject: Re: [sqlite] wha
I haven't test with different sizes at all?
JP
From: Roger Binns <rog...@rogerbinns.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Monday, April 20, 2009 5:11:48 PM
Subject: Re: [sqlite] what is the right cache_size
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Joanne Pham wrote:
> It it the right size for the cache_size? My applications have a lot of writes
> operations and can be up to millions rows per minutes.
What results did you get when you did your testing with different sizes?
Roger
-BEGIN
Hi All,
I am currently using sqlite 3.5.9 and I have set the cache_size as below:
sqlSt = sqlite3_exec(pDb, "PRAGMA cache_size = 2000 ", NULL, 0, );
It it the right size for the cache_size? My applications have a lot of writes
operations and can be up to millions rows per minutes.
Thanks,
JP
5 matches
Mail list logo