Thank you all for these tips. Very helpful! Op di 2 apr. 2019 om 08:35 schreef Rowan Worth <row...@dug.com>:
> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
