On 4 May 2015, at 6:43pm, Brandon Frye <brandon at cogent3d.com> wrote:

> Thanks so much for the response. Can you suggest the specific pragmas -
> although I trust your insight that they may be more harmful than helpful -
> I would like to read more about them (if for nothing else to make sure I
> have not used them trying to fix this!).

The ones which seem relevant are

PRAGMA cache_spill
PRAGMA checkpoint_fullfsync
PRAGMA fullfsync
PRAGMA synchronous
PRAGMA wal_autocheckpoint
PRAGMA wal_checkpoint

By all means experiment with them and see if they help.  I suspect that 
settings which cause more frequent updating of the database will just cause 
your crash to occur sooner,  but since the bug you seem to have discovered in 
iOS is not understood, perhaps one will avoid you triggering it.

Simon.

Reply via email to