On 6/8/2010 9:25 AM, Dan Kennedy wrote: > > Those pragmas should not cause a problem. Simon's referring > to "PRAGMA synchronous". The docs for which explain the > risks assumed by changing the default setting. > > http://www.sqlite.org/pragma.html#pragma_synchronous > > As Dan said, "PRAGMA synchronous" can cause database corruption under certain conditions of application or system failure.
Just as an FYI, "PRAGMA synchronous" will not cause database corruption in the latest Oracle Berkeley DB 11gR2 release that supports the SQLite API. The Berkeley DB write-ahead logging and recovery will ensure that the database remains consistent even in the event of application or system failure. Regards, Dave _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users