On 30 Dec 2017, at 5:37am, Ian Freeman <i...@ifreeman.net> wrote: > Agreed, the defaults would be very safe. But I realize I never > mentioned what my actual goal was: minimizing disk writes for a write- > heavy application. That's why I want to run -wal out of memory, or set > synchronous=NORMAL. Of course, I cannot do this at the expense of > integrity.
Accumulate your change commands in memory as text. Eventually execute them all inside BEGIN … COMMIT. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users