Performance Considerations

Sybase defines two bulk copy modes, described in the following table. Sybase automatically selects the appropriate mode at run time. For more information, refer to your Sybase documentation.

Table 1. Summary of Fast and Slow Bulk Copy Mode Characteristics
Characteristic Fast Bulk Copy Mode Slow Bulk Copy Mode
Destination Table Characteristics No indexes or triggers on destination table One or more indexes or triggers
Database Configuration Required The into/bulkcopy/pllsort dboption must be set to true. None
Logging Performed Page allocations are logged, but row inserts are not Row inserts are logged
Transaction Log Handling You must dump the database before backing up (dumping) the transaction log. The transaction log can become very large. After the bulk copy completes, back up your database with dump database, then truncate the log with dump transaction.