Helen;

Not that I doubt your expertise, becuase I don't, but turning forced
writes on to improve performance is somewhat counter-intuitive.

--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
> 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/
> _______________________________________________________