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