RE: [sqlite] How to speed up SQLite

> However, as SQLite files are single files, a crash during a > "non-important > transaction" could still hose the entire database. In this > sense, there is > no such thing as a non-important transaction. Hrm... A very good point. Thanks for spotting the flaw in my thinking. :) -Tom

RE: [sqlite] How to speed up SQLite

nstitutes a non-important update? > > -Tom > >> -Original Message- >> From: pippi pohopper [mailto:[EMAIL PROTECTED] >> Sent: Saturday, October 01, 2005 12:31 PM >> To: sqlite-users@sqlite.org >> Subject: [sqlite] How to speed up SQLite >&g

RE: [sqlite] How to speed up SQLite

--Original Message- > From: pippi pohopper [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 01, 2005 12:31 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] How to speed up SQLite > > I'm experimenting with SQLite and found there's a big > difference in spe

[sqlite] How to speed up SQLite

I'm experimenting with SQLite and found there's a big difference in speed depending on the setting of PRAGMA SYNCHRONOUS. I understand that settings other than"2" for this parameter don't guarantee that data is safely stored on disk when che COMMIT statement terminates. I wonder if it is possi