James Berry wrote:
PRAGMA default_synchronous doesn't seem to have any effect on my sqlite
3.0.8 installation.
PRAGMA default_synchronous;
doesn't return a result in the sqlite3 shell, and PRAGMA
default_synchronous=OFF doesn't seem to have any effect, either.
In contrast, PRAGMA synchronous does seem to be working.
Can anybody give me any ideas? Is it supposed to work? Is there a
misspelling somewhere?
PRAGME default_sychronous went away with version 3. It was judged
to be too dangerous. Somebody might turn it off then forget that it
was turned off and forever after the database would be in danger of
corruption by a power failure or OS crash. Better to turn
synchronous off at the beginning of each session that really
needs it and is will to take the risk.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
