AllowPrefetch

Description

Enables the prefetch feature. When enabled, the JDBC Client requests a next set of rows from the server while the client application is processing the previous set of rows.

This property can be specified using:

• JDBC data source
• URL
• java.util.properties
• server data source

Valid Values

0 | 1

When set to 1, the prefetch feature is enabled. Overall throughput increases, if the application always fetches all rows from a result set. When this feature is enabled and the application does not fetch all data from result sets, performance can be significantly degraded.

When set to 0, the prefetch feature is disabled.

Default

0

Data Type

boolean

Configuration

All