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