Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Connection Parameters and Network Protocol Options » Connection parameters

Password connection parameter [PWD] Next Page

PrefetchBuffer connection parameter [PBUF]

Sets the maximum amount of memory for buffering rows, in bytes.




Integer [ k | m ] between the default value and 8 MB


65536 (all platforms except Windows CE)

16384 (Windows CE)


The PrefetchBuffer (PBUF) connection parameter controls the memory allocated on the client to store prefetched rows. The default value is in bytes, but you can use k or m to specify units of kilobytes or megabytes, respectively. 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 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.

For compatibility with previous versions, if a value less than 16384 is specified, it is interpreted as kilobytes. Using kilobytes without the k suffix in the PrefetchBuffer connection parameter is deprecated, and will not be supported in future versions of the software. See PrefetchRows connection parameter [PROWS].

See also

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


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