Subject | mass inserts |
---|---|
Author | sboyd_kanservu_ca |
Post date | 2002-04-09T14:17:30Z |
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?
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?