The jConnect Driver now supports large insertions of rows to ASE 12.5.2 and later versions 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.
The enhanced jConnect Driver introduces a new property called ENABLE_BULK_LOAD which specifies whether or not to use bulk load to insert rows to the database. The values are:
False – Disable bulk load. Default.
True – Enable bulk load.
When you use prepared statements and ENABLE_BULK_LOAD is enabled, jConnect uses the BULK routines to insert a batch of records to the Sybase databases.
These datatypes and features are not supported:
unsigned types, bigint, and unitext
partition tables, encrypted columns, and computed columns
