[EMAIL PROTECTED] wrote: > In a message dated 11/3/2004 12:20:36 PM Eastern Standard Time, > [EMAIL PROTECTED] writes: > > How can I make sure after an insert that everything has been flushed > to disc? > > I mean, I want even my program to become slower as long as I know > everything have been written to disc. > > At the moment I am using: > PRAGMA default_synchronous = FULL; > PRAGMA synchronous = FULL; > > > And the queries are all INSERT's without a transaction. > > > Thx, > > KaReL (aka Steven) > > Main Webpage : _http://www.karels0ft.be/ > _ (http://www.karels0ft.be/) ICQ # : 35217584 > > > > If synchronus=FULL is set. every insert without a transaction is > flushed to disk before sqlite3_finalized is returned. You are safe. > > Wei
Unless you are using IDE disks that respond that they've written to the disk when in fact they have not. reid