Subject Re: [firebird-support] Embedded Firebird : Transaction
Author Ivan Prenosil
>> Unless you also have some triggers that repeatedly update the same rows,
>> you do not have to commit every "n" inserts, it will not speed up anything.
> I tried forcing commits only every 5k inserts (instead of after each
> one), and achieve a 2.8x speed increase. I don't have any triggers. Do
> you have more infos/url describing how firebird handles caching, commits
> and disks I/O for personal knowledge ?

Committing after each row is bad - each transaction require on average
two disk writes which is too expensive.

I never encountered any speed problems when inserting several million rows
inside single transaction. I have no idea why people keep recommending
committing periodically during insert process.