I would file that as a bug, or at least as needing to be documented.
> -----Original Message----- > From: Cronos [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 21, 2005 12:49 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Re: upgrade from 2 to 3 > > Nevermind, it seems I have found the cause, I was doing: > sqlthread->exec("PRAGMA synchronous = 0;",NULL,NULL); > sqlthread->exec("PRAGMA cache_size = 4000;",NULL,NULL); > > but changing it to this has sorted the problem out: > sqlthread->exec("PRAGMA cache_size = 4000;",NULL,NULL); > sqlthread->exec("PRAGMA synchronous = 0;",NULL,NULL); > > It seems the value of synchronous gets changed back to full > if you change the cache_size. > >