ginal Message-
From: Scott Krig [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 20, 2007 2:03 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Performance tuning using PRAGMA, other methods
There are apparently no folks with the experience to answer the
questions as given?
-Ori
> BTW, several PRAGMAS actually increase performance in my embedded app
> case - maybe 15-30% depending upon transaction activity and the way I
> structure transaction commits. Specific PRAGMAS that helped include:
This is exactly what irritates me about conversations like this - the
pragmas
On 11/30/07, Eduardo Morras <[EMAIL PROTECTED]> wrote:
> e) I'm not sure, but using a journaling or softupdate enabled
> filesystem should means you can disable syncronous pragma.
No; SQLite's synchronous code ensures data reaches disk intact and in
proper order at specific times, regardless of s
At 19:12 20/11/2007, you wrote:
What are the 'biggest bang for the buck' sqlite optimization techniques
to apply to a working system to tune performance?
Q1)) PRAGMA: Does anyone have experience and good results optimizing
sqlite performance using PRAGMA's? If so, which ones, how were they
used
DB to avoid lock/unlock for each transaction
//
rc = sqlite3_exec(*dbHandle, "PRAGMA locking_mode = exclusive;", 0,
0, 0);
-----Original Message-
From: Scott Krig [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 20, 2007 2:03 PM
To: sqlite-users@sqlite.org
Subject:
ott Krig [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 20, 2007 2:03 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Performance tuning using PRAGMA, other methods
There are apparently no folks with the experience to answer the
questions as given?
-Original Message-
From: To
ays what has the most impact.
> Pragmas, #defines, API usage, etc. are always a distant second in the
> race for performance gains.
>
>-T
>
> > -Original Message-
> > From: Scott Krig [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, November 20, 2007 4:24 PM
&
ssage-
From: Scott Krig [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 20, 2007 3:03 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Performance tuning using PRAGMA, other methods
There are apparently no folks with the experience to answer the
questions as given?
-Original Me
There are apparently no folks with the experience to answer the
questions as given?
-Original Message-
From: Tom Briggs [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 20, 2007 1:41 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Performance tuning using PRAGMA, other methods
ant second in the
race for performance gains.
-T
> -Original Message-
> From: Scott Krig [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 20, 2007 4:24 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Performance tuning using PRAGMA, other methods
>
>
Why not try benchmarking the pragmas yourself and posting your
findings to the list?
http://www.sqlite.org/pragma.html
--- Scott Krig <[EMAIL PROTECTED]> wrote:
> Q1)) PRAGMA: Does anyone have experience and good results optimizing
> sqlite performance using PRAGMA's? If so, which ones, how we
f any type would be appreciated.
-Original Message-
From: Tom Briggs [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 20, 2007 10:40 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Performance tuning using PRAGMA, other methods
Which pragmas will be most effective (and
nal Message-
> From: Scott Krig [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 20, 2007 1:13 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Performance tuning using PRAGMA, other methods
>
>
> What are the 'biggest bang for the buck' sqlite optimi
What are the 'biggest bang for the buck' sqlite optimization techniques
to apply to a working system to tune performance?
Q1)) PRAGMA: Does anyone have experience and good results optimizing
sqlite performance using PRAGMA's? If so, which ones, how were they
used, and what was the performance in
14 matches
Mail list logo
