Thanks Ann, for that positive advice. I'll follow it up.

Is there any direct implementation of 'no_auto_undo' in IBObjects?

Neville

----- Original Message -----
From: "Ann W. Harrison" <aharrison@...>
To: <IB-Conversions@yahoogroups.com>; "nevillerichards"
<neville@...>


> Neville,
>
> To make large inserts go faster:
>
> 1) Use prepared statements.
>
> 2) Commit blocks of 5-10,000 records rather than each record individually.
>
> 3) Connect with a database parameter block that includes 'no_auto_undo'.
>
> Regards,
>
>
> Ann
>