Matt Sergeant wrote: > On Mon, 17 Aug 2009 10:47:23 -0400, Angus March wrote: > >>> Because yes, that's what synchronous=OFF means. It stops SQLite from >>> issuing fflush calls (effectively). >>> >>> >> Right, and this is implied by the documentation, but I was concerned >> that the documentation might be playing fast and loose, saying that >> fflush (or fsync, or fdatasync) won't be called, when it really means >> that it won't be called during any call to step() or finalize(), while >> it would be called when the session is closed. I wasn't sure, so I >> thought I'd ask, because it'll matter to my app. >> > > Kernels will fflush when a file handle is closed, which will happen > when you close the database handle. >
Actually, looking at the man pages for fflush just the user-space buffers are flushed, and not the write-behind buffer in the kernel. If that's all SQLite does, that's ok. So again, if anyone knows that synchronous=OFF means that SQLite will not *deliberately* flush the kernel's write-behind cache *at any time* for the *rest of the session*, please let me know. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users