On 3/2/15, Doug Nebeker <admin at poweradmin.com> wrote: > >> Depends on whether you are using WAL mode or not. > > I am not using WAL. >
Then there is little performance impact from using PRAGMA synchronous=FULL versus PRAGMA synchronous=NORMAL. Both should work. I do not understand why you are seeing errors. Have you looked at https://www.sqlite.org/howtocorrupt.html to see if that offers any clues? -- D. Richard Hipp drh at sqlite.org