DisableMultiRowFetch Connection Parameter [DMRF]

Turns off multi-record fetches across the network.

Usage

Anywhere

Default

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

The following connection string fragment prevents prefetching:
```
DMRF=Yes
```