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
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
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
sqlite3_exec(*dbHandle, "PRAGMA read_uncommitted = 1;", 0, 0,0);
rc = sqlite3_exec(*dbHandle, "PRAGMA locking_mode = exclusive;", 0,0, 0);
Thank you so much.
JP
- Original Message
From: Scott Krig <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thur
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
hat 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
> > T
-
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 Message
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
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
>
> To the
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
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 what
Which pragmas will be most effective (and what values you should use
for each) depends on what you're trying to do with the database.
Synchronous is important if you're writing frequently, for example, but
won't matter much in a read-only setting. Appropriate values for the
page_size and
13 matches
Mail list logo