ASA Database Administration Guide
  Connection and Communication Parameters
    Connection parameters

PrefetchBuffer connection parameter [PBUF]

Function 

Set the maximum amount of memory for buffering rows, in kilobytes.

Usage 

Anywhere

Values 

Integer

Default 

16 (Windows CE) 64 (all other platforms)

Description 

The PrefetchBuffer (PBUF) connection parameter controls the memory allocated on the client to store prefetched rows. In some circumstances, increasing the number of rows prefetched from the database server by the client can improve query performance. You can increase the number of rows prefetched using the PrefetchRows (PROWS) and PrefetchBuffer (PBUF) connection parameters.

Increasing the PrefetchBuffer (PBUF) connection parameter increases the amount of memory used to buffer GET DATA requests. This may improve performance for some applications that process many GET DATA (SQLGetData) requests.

For more information, see PrefetchRows connection parameter [PROWS].

Examples 

• The following connection string fragment could be used to determine if the PrefetchBuffer memory limit is reducing the number of rows prefetched.

  ...PrefetchRows=100;Debug=YES;Logfile=c:\client.txt

• The following string could be used to increase the memory limit to 256K:

  ...PrefetchRows=100;PrefetchBuffer=256