skip to main content
DataDirect Connect Drivers : Informix Driver : Connection Properties : FetchBufferSize
  
FetchBufferSize
Purpose
Specifies the size (in bytes) of the fetch buffer that the driver uses when retrieving data from the database.
Decreasing the fetch buffer size reduces memory consumption, but means more network round trips, which decreases performance. Increasing the fetch buffer size improves performance because fewer network round trips are needed to return data from the database.
To determine the optimal value, use the following formula:
X = A * B * 50
where:
A
is the number of rows that your application returns when executing Select statements
B
is the number of row columns that are typically returned when executing Select statements.
Valid Values
x
where:
x
is a positive integer from 1 to 32767 that represents the size of the fetch buffer.
Default
32767
Data Type
int
See also
Performance Considerations