[EMAIL PROTECTED] wrote:
Dennis Jenkins <[EMAIL PROTECTED]> wrote:
these are the settings that our app uses when it creates/opens the sqlite
database:
db.ExecuteImmediate("PRAGMA synchronous=OFF");
With synchronous=OFF, a power failure might result in database
corruption. Is this an issue for you?
--
D. Richard Hipp <[EMAIL PROTECTED]>
Not really. The data can be regenerated by the user without too much
difficulty. I don't have the numbers handy, but I seem to remember that
I did some performance experiments and determined that the performance
gains significantly outweighed the potential problems. To my knowledge,
for the past two years, only one user (out of many hundreds) has ever
gotten a corrupt database.
I suppose I'll put in a ticket into our issue tracking system to review
this decision. According to a comment in our source code, I based this
action on
http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragma-synchronous
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------