--- In firebird-support@yahoogroups.com, "spif1973" <MBU@t...> wrote:

> Thanks a lot for the replys - I guess I should trust my commits to

do

> they work :).

Martin, commit in FB do'nt commit every changed record, it is very
cheap thing - just set flag on transaction frame in Transaction
Inventory Pages. Versions of the records created by statements are
marked with transaction number in which context this statements were
made and server checks flag of appropriate transactions when combining
visible to accessing this record transaction version of the record. So
last you'll bother about when power fails is partly commited changes -
it is just impossible. Possible is corruption because of non flushed
to disk cache, which server detects on next start and refuses to work
with damaged tables or even database itself. So it is recommended to
use Forced Writes flag On to minimize this risk. Note FW don't affect
generators so after power failure you can encounter exceptions like
"attempt to store duplicate value in unique index" while generators
don't reach proper values.

Best regards,
Alexander.