DisableMultiRowFetch Connection Parameter [DMRF]

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

This connection string fragment prevents prefetching:

DMRF=Yes
Parent topic: Connection Parameters