On 30 Dec 2017, at 4:38pm, Ian Freeman <i...@ifreeman.net> wrote:
> Naturally, and of course. The point of my initial post was that I was still > seeing sync operations with synch=NORMAL when I shouldn't have according to > the below docs (now debatable whether they were actually written to disk or > just the os cache). I purposely configured synch to NORMAL to avoid the > additional sync to the -wal file, but was still seeing it in operation. I can explain that. Sync happens automatically when the OS wants it to happen. This may be when a cache busts and has to be written to disk, though some OSen have a regular timer and do a sync every minute (for example) and others trigger a sync when swapping a process out. You cannot prevent these syncs at the App level: the OS or File System triggers them. What the SQLite setting does is tell SQLite to ask for /additional/ syncs when SQLite thinks they’re needed. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
