Re: [sqlite] journey mode TRUNCATE is to append ? not overwrite?

On 1/06/2009 5:29 PM, pierr wrote: > 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 s

[sqlite] journey mode TRUNCATE is to append ? not overwrite?

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