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.

Data Source Methods

public Integer getFetchBufferSize()

public void setFetchBufferSize(Integer)

Default

32767

Data Type

Integer

See also

Performance considerations