"jayanth KP" <[EMAIL PROTECTED]> wrote: > Hi Richard, > > We are ALREADY using sqlite 2.8.13.
Your original post said you were using 2.8.3. Must have been a typo. > > OBSERVATIONS: > ------------- > > 1) If i call sync() system call after database update, the database is not > getting corrupted. SQLite calls sync() twice during each COMMIT, unless you have it disabled. My guess is that you must be doing PRAGMA synchronous=OFF; Or perhaps you are compiling with -DSQLITE_NO_SYNC=1. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------