On May 29, 2008, at 4:13 PM, Bob Ebert wrote: > I was under the impression that setting PRAGMA synchronous=NORMAL also > removed the fsync() at step 6. I'm pretty sure when we run with > synchronous=NORMAL we see only one fsync() call per COMMIT operation, > not 2 (and definitely not 3 as we see with synchronous=FULL). >
Each COMMIT with synchronous=NORMAL should do one fsync() of the journal file and one fsync() of the database file. There might also be an fsync() of the directory that contains the journal and database files when the journal file is first created. (Not sure about that last one -- been a while since I looked at that code.) D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
