I am commiting ever 10000 records.

mike

-----Original Message-----
From: Paul Reeves [mailto:paul@...]
Sent: Wednesday, August 15, 2001 10:09 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Importing Records


Mike Grover wrote:

>
> I have run into a interesting problem...
>
> while inserting records into my file,
>
> the more records i get added in the slower it gets?
>
> at the start I am getting about 18,000 records per second.
> at the 50 million record mark, it tkaes 30 seconds to add 10,000 records?
>

Try doing a commit every million records.

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/