RE: [sqlite] Performance tuning using PRAGMA, other methods

rc = sqlite3_exec(*dbHandle, "PRAGMA read_uncommitted = 1;", 0, 0, 0); // // Exclusive access to DB to avoid lock/unlock for each transaction // rc = sqlite3_exec(*dbHandle, "PRAGMA locking_mode = exclusive;", 0, 0, 0); -----Original Message- From: Sc

RE: [sqlite] Performance tuning using PRAGMA, other methods

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 > >

RE: [sqlite] Performance tuning using PRAGMA, other methods

ther the database is write-mostly or read-mostly and also depending on whether you want to optimize for reading or writing. So in short, the answer is, it depends. Depends on what you're trying to tune for, that is. -T > -Original Message- > From: Scott Krig [mailto:[EM

[sqlite] Performance tuning using PRAGMA, other methods

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