On Jul 14, 2006, at 23:43 UTC, Kees Nuyt wrote: > The syntax descriptions about PRAGMA synchronous= could shed > some light. http://www.sqlite.org/pragma.html#modify > Note: The default for the "synchronous" PRAGMA is version > dependent.
That's interesting. What is "the F_FULLFSYNC syncing method" (since I am running on Mac OS X)? For what it's worth, PRAGMA FULLFSYNC returns 0 on my database. PRAGMA SYNCHRONOUS returns 2, which should be the safest mode. I am at a loss. Best, - Joe -- Joe Strout -- [EMAIL PROTECTED] Verified Express, LLC "Making the Internet a Better Place" http://www.verex.com/