The number of bytes the driver can fetch in a single network round trip. Larger values increase throughput by reducing the number of times the driver fetches data across the network. Smaller values increase response time, as there is less of a delay waiting for the server to transmit data.
Valid Values
An integer from 1 to 4,294,967,296 (4 GB)
The value 1 does not define the number of bytes but, instead, causes the driver to allocate space for exactly one row of data.
Notes
This connection option can affect performance.
The setting of the Array Size property can be overridden by specifying the number of rows to fetch using the SQL_ATTR_ROW_ARRAY_SIZE statement attribute. When issuing the statement attribute, the driver calculates the internal buffer size for a fetch by multiplying the number of rows specified by the row size reported in the server metadata. Therefore, specifying large values may improve throughput, but it does so at the expense of increased demands on memory.
This connection option can affect performance.