On 10/16/17, David Raymond <david.raym...@tomtom.com> wrote: > The setting for synchronous is basically what level of safety net do you > want if it dies in the middle of something. Setting it to off shouldn't > cause any corruption if things go well, it should only come into play if you > saw errors or didn't close things down correctly etc.
Actually, synchronous=off is safe as long as you don't take a hard-reboot or power loss in the middle of a transaction. An application crash with synchronous=off should be harmless. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users