Subject Re: [ib-support] mass inserts
Author Helen Borrie
At 02:17 PM 09-04-02 +0000, you 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?

Yup...turn forced writes back on and commit about every 15,000 rows.


All for Open and Open for All
Firebird Open SQL Database · ·