Subject Re: [firebird-support] Embedded Firebird : Transaction
Author Ann W. Harrison
Nando Dessena wrote:

> IP> Unless you also have some triggers that repeatedly update the same rows,
> IP> you do not have to commit every "n" inserts, it will not speed up anything.
> According to my experience, if the available RAM is exhausted by
> Firebird running a very long transaction, splitting it *will* help
> performace. I don't know if the OP is inserting thousands or millions
> of records, so I took the safer approach.

A transaction, even a long transaction that does lots of inserts should
not exhaust RAM. Gbak restores entire databases in a single transaction.