jConnect supports large insertions of rows to Adaptive Server version 12.5.2 and later using bulk load inserts. Although this feature does not require special configuration on the server, a larger page size, network packet size, and max memory size significantly improves performance. Depending on the client memory, use of larger batches also improves performance.
To enable this feature, set ENABLE_BULK_LOAD to True. When you use prepared statements and ENABLE_BULK_LOAD is True, jConnect uses the BULK routines to insert a batch of records to the Sybase databases.
BCP insert does not support:
unsigned types, bigint, and unitext
encrypted columns and computed columns
