Hi all, Section 7.9 of http://www.sqlite.org/atomiccommit.html mentioned:
"On embedded systems with synchronous filesystems, TRUNCATE results in slower behavior than PERSIST. The commit operation is the same speed. But subsequent transactions are slower following a TRUNCATE because it is faster to overwrite existing content than to append to the end of a file. New journal file entries will always be appended following a TRUNCATE but will usually overwrite with PERSIST." why " New journal file entries will always be appended following a TRUNCATE but will usually overwrite with PERSIST"? I think if we trancate the journey file to _zero_ , and the following write to that file is going to overwrite the old data. Why append? Thanks. -- View this message in context: http://www.nabble.com/journey-mode-TRUNCATE-is-to-append---not-overwrite--tp23810973p23810973.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
