> >I have a program which is written with firebird API, I've tried to
> >set the option of database Forced Writes to Disabled and then insert
> >several numbers of record and suddently shut down the server, surely
> >the data is lost. I know that the data is physically write to db only
> >when the program disconnect to the db
>
> Not true. With Forced Writes enabled, the data is written immediately to
> disk. (On Windows, don't judge by what the filesystem tells you about file
> growth. Windows doesn't refresh that information until the file is
> physically closed.)

The Firebird's cache works even with Forced Writes On,
so data are usually NOT written immediately, but when the cache
needs to be emptied or before commit/rollback.

Ivan
http://www.volny.cz/iprenosil/interbase/