On Feb 22, 2008, at 4:57 PM, [EMAIL PROTECTED] wrote: > That depends on your filesystem. On many modern file > systems you can safely omit 3 and 4. And if the > xDeviceCharacteristics() method of the VFS implementation > for a particular filesystem reports SQLITE_IOCAP_SAFE_APPEND, > then SQLite skips steps 3 and 4. Steps 3 and 4 are > also skipped if you set > > PRAGMA synchronous=NORMAL; > > instead of the default > > PRAGMA synchronous=FULL; > > It has been reported to us that by omitting steps 3 and > 4 you get about a 30% speed improvement on MacOS X.
So, is safe so to set PRAGMA synchronous=NORMAL; under MacOS X? It would be really nice to know under which modern file system it is safe to skip 3 and 4. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
