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

PrefetchOnOpen connection parameter Next Page

PrefetchRows connection parameter [PROWS]

Sets the maximum number of rows to prefetch when querying the database.







200 for ADO.NET


Increasing the number of rows prefetched from the database server by the client can improve performance on cursors that only fetch relative 0 or 1, with either single row or wide fetches. Wide fetches include embedded SQL array fetches and ODBC block fetches.

Improvements occur particularly under the following conditions:

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 connection parameter [PBUF].

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

See also

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