Subject | Re: mass inserts |
---|---|
Author | Aage Johansen |
Post date | 2002-04-09T18:20:27Z |
sboyd_kanservu_ca wrote:
Regards,
Aage J.
> I am having a performance problem with IB56 on NT while insertingThis reminds me of what happened when I used the BDE (a few years back).
> 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?
Regards,
Aage J.