"Scott Gilbert" <[EMAIL PROTECTED]> wrote: > > So my questions are: > > With synchronous = 0, are transactions still atomic across processes?
yes > Is running with synchronous=0 likely to non-recoverably corrupt the > database file on power failure? yes > Are there any recovery tools that can restore consistancy? no. As it happens, I am currently working on an article that attempts to explain exactly how the atomic commit mechanism in SQLite works. I have posted a draft at http://www.sqlite.org/ac/atomiccommit.html This draft is incomplete. It has not been proofread. It has not even been spell-checked. I was still actively typing it in when I paused to check email and saw your message. Nevertheless, it might be able to give you some insight into why your questions must be answered in the way that they are, despite your likely disappointment. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
