[sqlite] NOP INSERT still writes to the DB/journal

[Simon Slavin]

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.