{ PrefetchBuffer | PBUF }=buffer-size[ k | m ]

Anywhere

512 KB (524288) all platforms except Windows Mobile

64 KB (65536 bytes) Windows Mobile

The PrefetchBuffer (PBUF) connection parameter controls the per-connection maximum memory allocated on the client to store prefetched rows.

In some circumstances, increasing the number of prefetched rows can improve query performance. You can increase the number of prefetched rows using the PrefetchRows (PROWS) and PrefetchBuffer (PBUF) connection parameters.

Increasing the PrefetchBuffer (PBUF) connection parameter also 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.

• Connection parameters and connection strings

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

...PrefetchRows=100;LogFile=c:\client.txt

The following string could be used to increase the memory limit to 2 MB:

...PrefetchRows=100;PrefetchBuffer=2M