skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The Sybase Wire Protocol Driver : Performance Considerations
  
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 37. 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.