Re: [sqlite] Flush to disc

2004-11-03 Thread Konstantin Malakhanov
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

RE: [sqlite] Flush to disc

2004-11-03 Thread Reid Thompson
[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

[sqlite] Flush to disc

2004-11-03 Thread Steven Van Ingelgem
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