On 11/03/2004 08:48 PM, Reid Thompson wrote: > [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.
..or you have some transaction-based/journaling filesystem which delays data writing to disk ;-) > reid > > -- Konstantin Malakhanov <[EMAIL PROTECTED]>
