Subject RE: [firebird-support] Best Practice Question - How many rows to update before commit?
Author Leyne, Sean

> I'm trying to balance performance vs. reliability here. The data load
> takes
> about 3 hours to finish, so frequent commits could have dramatic
affect on
> the length of time that this has to run, and as it is run nightly in
> cases, I need to find a way to do this as quickly and reliably as
> possible.

Actually, a commit every 5000 to 10000 rows will give you a good

One comment though, 500,000 rows should load at the rate of about 1,000
per second (I got this and I'm a lousy Delphi programmer), but you need
to use prepared queries and parameters to accomplish this. So, 3 hours
of import time seems very wrong.