]
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: Tom Briggs [mailto:[EMAIL PROTECTED]
Sent
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
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
, 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: Tom Briggs [mailto:[EMAIL PROTECTED]
Sent: Tuesday
= 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: Thursday, November 29, 2007 10:56:37 AM
Subject: RE: [sqlite] Performance tuning using PRAGMA, other methods
BTW
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
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
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 were
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 point, the questions are:
Q1
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
-
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
than enough information for the level of
detail you want.
Regards,
~Nuno Lucas
-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
13 matches
Mail list logo