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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Connection parameters and network protocol options » Connection parameters

 

DisableMultiRowFetch connection parameter [DMRF]

Turns off multi-row fetches across the network.

Usage

Anywhere

Values

YES, NO

Default

NO

Remarks

By default, when the database server gets a simple fetch request, the application asks for extra rows. You can disable this behavior by setting this parameter to YES.

See Using cursors in procedures and triggers.

Setting the DisableMultiRowFetch (DMRF) connection parameter to YES is equivalent to setting the prefetch database option to Off.

See Prefetching rows.

See also
Example

The following connection string fragment prevents prefetching:

DMRF=YES