SqlCE has a parameter set on the Connect String called Flush Interval. It is defined as:

The interval time (in seconds) before all committed transactions are flushed to disk. If not specified, the default value is 10.

I thought that a committed transaction, by definition, is a transaction that has been flushed to disk, specifically the database file. If a transaction is only stored in RAM then cannot the transaction be easily lost?

I thought that transactions were first written to a log file and then applied to the database file itself, so perhaps this parameter could mean the time to wait until the transaction log is applied to the database file?

I would have thought that this parameter should be 0.