Subject RE: [ib-support] Importing Records
Author Mike Grover
Straight Inserts

-----Original Message-----
From: Paul Reeves [mailto:paul@...]
Sent: Thursday, August 16, 2001 2:53 AM
Subject: Re: [ib-support] Importing Records

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

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to