Ivan,

>>> - 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.

Ciao
--
Nando Dessena
http://www.flamerobin.org