-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/12/2011 11:54 AM, Simon Slavin wrote: > Compensating for this behaviour is a big part of what SQLite does in > journaling.
SQLite and other journalling mechanisms depend on an operating system call fsync that flushes their relevant data to the hard disk, and that the hard flush any buffered writes it has, only returning when everything is written and would be present should there be an abrupt power failure. About 7 years ago this issue was very prominent. It was discovered that a fair number drives lie in response to that command to flush buffers. Some operating systems (cough Mac cough) would even lie in response to the system call fsync. Making hard drives use write through instead of write behind helps. Some interesting related posts for people wondering about durability: http://community.livejournal.com/lj_dev/670215.html http://blogs.msdn.com/b/oldnewthing/archive/2010/09/09/10059575.aspx http://peter-zaitsev.livejournal.com/11177.html http://brad.livejournal.com/2116715.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk1W7PcACgkQmOOfHg372QRuOgCgjX6VJVtoih6HXqcwagf4Wi3l U+EAnR0RbSYaIyLoTXmSpVDRHouma1tL =XRFx -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users