Other ways to increase bulk-copy performance are:
Set the trunc log on chkpt option to keep the transaction log from filling up. If your database has a threshold procedure that automatically dumps the log when it fills, you save the transaction dump time
Each batch is a separate transaction, so if you do not specify a batch size, setting trunc log on chkpt does not improve performance.
Set the number of pre-allocated extents configuration parameter high if you perform many large bulk copies.
See Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide: Volume 1.
Find the optimal network packet size.
See Chapter 2, “Networks and Performance,” in Performance and Tuning Series: Basics.
