SAP jConnect supports large insertions of rows to SAP Adaptive Server version 12.5.2 and later using bulk-load inserts.
Although this feature does not require special server configuration, a larger page size, network packet size, and maximum memory size significantly improves performance.
Additionally, depending on the client memory, using of larger batches also improves performance.
To enable bulk-load inserts, set ENABLE_BULK_LOAD to one of these values:
ARRAYINSERT_WITH_MIXED_STATEMENTS – enables bulk loading with row-level logging, and allows your application to execute other statements during the bulk-load operation.
ARRAYINSERT – enables bulk loading with row-level logging, but your application cannot execute other statements during the bulk-load operation.
BCP – enables bulk loading with page-level logging; your application cannot execute other statements during the bulk-load operation.
LOG_BCP – enables the bulk loading with page-level logging using the SAP Adaptive Server fast-log BCP feature; your application cannot execute other statements during the bulk-load operation.
When you use prepared statements, and ENABLE_BULK_LOAD is set to a valid value, SAP jConnect uses the BULK routines to insert a batch of records into SAP databases.