>
>On 4/18/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote:
>>
>>cache is per-connection so if you open and close connections a lot then a
>>large cache won't help your program. The command line app is a single
>>connection so a large cache there will help (although not with the first
"Jonas Sandman" <[EMAIL PROTECTED]> wrote:
> What is the default setting for PRAGMA cache_size ?
> Where is it defined?
>
The default size is 2000. You can change this at compile-time
by setting -DSQLITE_DEFAULT_CACHE_SIZE=12345
--
D. Richard Hipp <[EMAIL PROTECTED]>
sition is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
-Original Message-
From: Alberto Simões [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 18, 2007 3:59 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Efficiency and Pragmas
Hi
I am using these pragmas for effi
PROTECTED]
Sent: Wednesday, April 18, 2007 3:59 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Efficiency and Pragmas
Hi
I am using these pragmas for efficiency in data loading (I hope)
PRAGMA page_size = 4096;
PRAGMA temp_store = MEMORY;
PRAGMA cache_size = 100;
PRAGMA
Hi
I am using these pragmas for efficiency in data loading (I hope)
PRAGMA page_size = 4096;
PRAGMA temp_store = MEMORY;
PRAGMA cache_size = 100;
PRAGMA synchronous = OFF;
PRAGMA count_changes = 0;
The truth is that adding these pragmas my inserts got quite faster.
Now the
5 matches
Mail list logo