Re: [sqlite] Efficiency and Pragmas

2007-04-18 Thread Eduardo Morras
> >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

Re: [sqlite] Efficiency and Pragmas

2007-04-18 Thread drh
"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]>

Re: [sqlite] Efficiency and Pragmas

2007-04-18 Thread Jonas Sandman
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

RE: [sqlite] Efficiency and Pragmas

2007-04-18 Thread Samuel R. Neff
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

[sqlite] Efficiency and Pragmas

2007-04-18 Thread Alberto Simões
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