Re: [sqlite] pragma synchronous=off and journal_mode=wal still syncs to disk

2012-10-17 Thread Bob Price
yahoo.com>; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wednesday, October 17, 2012 11:32 AM Subject: Re: [sqlite] pragma synchronous=off and journal_mode=wal still syncs to disk On Wed, Oct 17, 2012 at 11:04 AM, Bob Price <rjp_em...@yahoo.co

Re: [sqlite] pragma synchronous=off and journal_mode=wal still syncs to disk

2012-10-17 Thread Richard Hipp
On Wed, Oct 17, 2012 at 11:04 AM, Bob Price wrote: > 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 >

[sqlite] pragma synchronous=off and journal_mode=wal still syncs to disk

2012-10-17 Thread Bob Price
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