On 29 Jun 2016, at 3:53pm, Joe Pasquariello <j...@fenway.com> wrote:
> Okay, thanks. I thought it was generally preferable to use "lower" levels of > synchronous. No. Other way around. Two principles to guide you through the use of PRAGMAs: A) The default settings are meant to be safe, probably safest. B) If it makes something faster, it's dangerous in some way. Otherwise it would be the default. See (A). So start off by leaving all PRAGMAs alone. Only if you have performance problems think about changing them. There are a couple of exceptions (e.g. journal_mode) but that's the way to bet. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
