ASA Database Administration Guide
  Connection and Communication Parameters
    Network communications parameters

PreFetchOnOpen communication parameter

Usage 

ODBC

Values 

YES, NO

Default 

NO

Description 

Enabling this option sends a prefetch request with a cursor open request, thereby eliminating a network request to fetch rows each time a cursor is opened. Columns must already be bound in order for the prefetch to occur on the open. Rebinding columns between the cursor open and the first fetch when using PrefetchOnOpen will cause reduced performance.

Calling ODBC's SQLExecute or SQLExecDirect on a query or stored procedure which returns a result set causes a cursor open.

Enabling this option can improve performance if your:

• network exhibits poor latency

• application sends many cursor open and close requests