>> While I can send 'set pragma synchronous=normal' at every write ... > > You don't have to execute the pragma for every write. > Once you've set synchronous=normal, it stays normal > until you close and reopen the database.
Not strictly true, in 3.2.1 it gets reset if you change the cache_size - see ticket 1260, just been fixed I think.
