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
