Row buffering

NZAE_ROW_BUFFER

Controls the data transmission behavior of input and output rows between the NPS system and an AE. Multiple rows can be packed into a buffer, reducing the number of process context switches between the NPS system and the AE.

NZAE_ROW_BUFFER={NO | RESULT | FULL}

When set to NO, the default, no buffering takes place. With RESULT, only result rows are buffered. With FULL, input and output rows are buffered. Full buffering of input and output affects SQL behavior, whereas result only buffering does not. For more information, see Understanding row buffering.