Straight Inserts

-----Original Message-----
From: Paul Reeves [mailto:paul@...]
Sent: Thursday, August 16, 2001 2:53 AM
To: ib-support@yahoogroups.com
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
--

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


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/