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

Reply via email to