Mike Grover wrote:

>
> I am commiting ever 10000 records.
>

Are you doing straight inserts, or are there updates involved?

I haven't every tried to insert millions of records in one hit, but I
have done smaller bulk loads. Straight inserts have been fine, but
updating even a single column simulataneously causes a serious
performance drain.

BTW, have you disabled the non-system generated indexes? The only active
index you want/need for this is the primary key.


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further