Even with Synchronous = off
Sqlite will flush its buffers upon the commit! As a "close" system call is
performed!
The next step is to Delete the file. :) (the commit point).
"Jay A. Kreibich" <[EMAIL PROTECTED]> wrote: On Fri, Apr 11, 2008 at 03:28:47PM
+0200, Martin Engelschalk scratched on the wall:
> Hello Donald,
>
> I don't think so: The journal files are not synchronized on SYNCHRONOUS
> = OFF, but they are still written, so transactions are still possible.
Yes, but if I understand the SYNCHRONOUS=OFF setting correctly, there
is no reason the believe the journal files will ever make it out of the
operating system's file cache. Even if the OS does decide to spool
them off to disk, that's going to happen in an async manner.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"'People who live in bamboo houses should not throw pandas.' Jesus said that."
- "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006"
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
