Subject mass inserts
Author sboyd_kanservu_ca
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?