> > Database corruption is uncommon. The usual causes are > > (1) Running with synchronous=OFF
Which just about sums it up! But, a question, I assume there is no risk if you are only using selects, i.e. the db is read only. Is there any performance advantage in having synchronous off in these circumstances? I suspect not. I have in mind another scenario, that of bulk inserts to a newly created table. Would it be viable and safe to: PPRAGMA synchronous=OFF Create table (with no indices) Insert ad nauseum PPRAGMA synchronous=FULL Create Index....
