DisableMultiRowFetch connection parameter [DMRF]

Function

Turns off multi-record fetches across the network.

Usage

Anywhere

Default

No

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 ON.

Setting the DisableMultiRowFetch parameter to ON is equivalent to setting the PREFETCH option to OFF.

Example