It appears that regardless of a "pragma synchronous=off" that there are still syncs to disk done at key points in WAL mode such as in a "pragma wal_checkpoint(RESTART)". I think that this is true based on the application cpu and disk I/O patterns I observe when logging shows the wal checkpoint to be in progress, while running on a Linux host with tons of free memory available for its file cache.
Is this true? Is there any way to configure a connection so that these syncs do not happen in WAL mode? Thanks, Bob _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users