Fetch Buffer Size
The size of the buffer that the connector uses for data retrieval, in bytes. The minimum value for the buffer size is 32000 (32 KB).
This property determines the maximum number of rows that the connector can retrieve each time during array fetches. The maximum number of rows is calculated using the MEMLIM value and the maximum size of one row.
Note:
To confirm the number of rows that the connector retrieves at a time based on your
MEMLIM setting, enable connector logging on the DEBUG level and then run a query. The log file includes information about the number of rows per fetch relative to the MEMLIM setting.
For information about configuring logging when using the Windows connector, see Configuring Logging Options.
For information about configuring logging when using a non-Windows connector, see Configuring Logging Options.
| Key Name | Default Value | Required |
|---|---|---|
|
|
|
No |