Subject Re: [ib-support] Importing Records
Author Paul Reeves
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 Reeves
taking InterBase further