On 2 Mar 2015, at 4:45pm, Doug Nebeker <admin at poweradmin.com> wrote:
> 1. Is setting synchronous to FULL necessary to prevent these corruption > problems? You should not be getting this corruption problem, so I don't know whether FULL would cure it. > 2. NORMAL is much slower than NONE. Is FULL much slower than NORMAL? Sorry but it's too hard to predict 'much' since the amount of time taken varies with different versions of the OS, width of the data bus, disk format, and other such things. All you can do is try it on your own specific setup. In the meantime ... Are you using any PRAGMAs apart from "PRAGMA synchronous" ? Are you testing the result codes of /all/ your sqlite3_ calls to check that they're SQLITE_OK ? Sometimes it's not the expected call which causes the corruption, or which first returns an error because the database is corrupt. Once the database is reported as corrupt, are you replacing it with a known good one before continuing ? Corruption is not automatically fixed and once a database is corrupt it will remain corrupt until something is done about it. Simon.
