Subject Re: [firebird-support] Embedded Firebird : Transaction
Author Nando Dessena

>>> - commit every "n" inserts, where "n" is usually in the thousands.
>> That exactly what I'm trying to do.

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.

Nando Dessena