{ PrefetchRows | PROWS }=number-of-rows

Anywhere

10

200 for ADO.NET

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.

The number of prefetched rows is limited by the PrefetchBuffer (PBUF) connection parameter, which limits the memory available for storing prefetched rows.

The maximum number of rows that can be prefetched is 10000.

• PrefetchBuffer (PBUF) connection parameter
• Connection parameters and connection strings

The following connection string fragment sets the number of prefetched rows to 100:

...PrefetchRows=100;...