Hello drh, You tested under Windows with synchronous=OFF? I mean specifically that way. I've never seen Sqlite trash a DB when I had synchronous turned on even with app crashes.
C Thursday, February 22, 2007, 9:56:57 AM, you wrote: dhc> Teg <[EMAIL PROTECTED]> wrote: >> >> I'm pretty sure an application crash even without power failure can >> corrupt to. At least in my experience. I keep synchronous on and >> simply use "insert or ignore" syntax within a transaction to get >> performance. >> dhc> It is not suppose to. There are extensive tests in the test dhc> suite where we simulate application crashes and verify that the dhc> database is not corrupted. If you encounter a situation where dhc> the database is corrupted, that is a bug and you should report dhc> it. dhc> -- dhc> D. Richard Hipp <[EMAIL PROTECTED]> dhc> ----------------------------------------------------------------------------- dhc> To unsubscribe, send email to [EMAIL PROTECTED] dhc> ----------------------------------------------------------------------------- -- Best regards, Teg mailto:[EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------