Myles,

> 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

most

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

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.


Sean