The number of rows prefetched is limited both by the PrefetchRows (PROWS) connection parameter and the PrefetchBuffer
(PBUF) connection parameter, which limits the memory available for storing prefetched rows. See PrefetchBuffer (PBUF) connection parameter.
The maximum number of rows that can be prefetched is 10000.
By default, the client library dynamically increases the number of prefetch rows for cursors that would gain a performance
benefit from such an increase. Because of this behavior, increasing the PrefetchRow default does not significantly improve
the performance of most applications.
Increasing the PrefetchRow default may improve the performance of ODBC, OLE DB, and SQL Anywhere JDBC applications that use
STATIC or FORWARD ONLY FOR UPDATE cursor types but do mostly fetch next operations and very rare positioned updates or deletes,
particularly if the client and database server are communicating over a slow or wide area network.