If I understood correctly when no transaction is specified an implicit transaction is created so there is no point to create a transaction for only one statement.
Cheers ! > Tue Dec 08 2015 5:51:35 am CET CET from "Simon Slavin" ><slavins at bigfraud.org> Subject: Re: [sqlite] NOP INSERT still writes to the >DB/journal > > On 8 Dec 2015, at 12:19am, Patrick Donnelly <batrick at batbytes.com> wrote: > > >>There are still writes: >> > Because you have not defined any transactions, each of your INSERT >commands it getting wrapped in its own transaction. A transaction has to >involve writes to disk. > > Try this ... > > BEGIN > INSERT INTO t1 ... > END > > See whether the INSERT command still involves as much writing. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?