On Mon, 1 Apr 2019 at 19:20, Domingo Alvarez Duarte <mingo...@gmail.com> wrote:
> Hello Gert ! > > I normally do this (be aware that if there is a power outage the > database is screwed): > > === > > PRAGMA synchronous = OFF; > begin; > > --processing here > > commit; > PRAGMA synchronous = ON; > You can probably leave the pragma alone without overly affecting import time tbh. The main thing is putting all the work into one transaction, and at that point you're down to 2 or 3 sync() calls. I guess there's still value in not having to wait for the journal to hit disk though. Maybe even PRAGMA journal_mode = OFF would be appropriate. -Rowan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users