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.

---H


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________