Subject Re: mass inserts
Author Aage Johansen
sboyd_kanservu_ca wrote:
> I am having a performance problem with IB56 on NT while inserting
> large numbers of records into a virgin database. It is taking 1.5
> hours to insert 250,000 rows for a simple row (< 20 columns). I have
> disabled all indices except the primary key, I have disabled forced
> writes and I insert all rows in 1 transaction. I notice the more rows
> I insert, the longer it takes to insert 1 row.
> Is there anything that I can do to speed this process up?


This reminds me of what happened when I used the BDE (a few years back).


Regards,
Aage J.