Hello drh,
Thursday, February 22, 2007, 9:08:08 AM, you wrote:
dhc> 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");
dhc> With synchronous=OFF, a power failure might result in database
dhc> corruption. Is this an issue for you?
dhc> --
dhc> D. Richard Hipp <[EMAIL PROTECTED]>
dhc>
-----------------------------------------------------------------------------
dhc> To unsubscribe, send email to [EMAIL PROTECTED]
dhc>
-----------------------------------------------------------------------------
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.
--
Best regards,
Teg mailto:[EMAIL PROTECTED]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
