skip to main content
DataDirect Connect Drivers : PostgreSQL Driver : Connection Properties : BulkLoadBatchSize
  
BulkLoadBatchSize
Purpose
Provides a suggestion to the driver for the number of rows to load to the database at a time when bulk loading data. Performance can be improved by increasing the number of rows the driver loads at a time because fewer network round trips are required. Be aware that increasing the number of rows that are loaded also causes the driver to consume more memory on the client.
Valid Values
x
where:
x
is a positive integer that represents a number of rows.
Notes
*This property suggests the number of rows regardless of which bulk load method is used: using a DDBulkLoad object or using bulk load for batch inserts.
*The DDBulkObject.setBatchSize() method overrides the value that is set by this property. Refer to "JDBC Extensions" in the DataDirect Connect Series for JDBC Reference for a description of the method.
Default
1000
Data Type
long
See also
Using DataDirect Bulk Load