Subject Re: R: [IBO] Faster Datapump from FoxPro/Paradox to Firebird
Author Jason Wharton
> Also, you might want to control your transactions, i.e. commit
> only after 100 inserts.

Transactions are a function of your unit of work, period.
There is no mystical threshold that you reach as far as size goes and there
is absolutely no performance benefit here.
Start a transaction, insert all your records and then commit once even if it
runs an hour.
Only do commits along the way if you have also included the ability to
piecemeal a dataload in the event of a failure part way through and you want
to be able to start up close to where you left off. Usually not worth the
trouble to do this unless you anticipate failure. If so, insert via a stored
procedure, catch any possible exception and log the failed record aside and
deal with it when complete.

Jason Wharton
CPS - Mesa AZ