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 whether using a DDBulkLoad object or using native bulk protocols in the database for batch inserts.
This property suggests the number of rows regardless whether using a DDBulkLoad object or using native bulk protocols in the database for batch inserts.