MultiRowInsert

The MultiRowInsert parameter enables or disables the High-speed Apply Engine’s processing of multiple row insert actions.

When the value of this parameter is Yes, High-speed Apply Engine can insert more than one row into a target table in one insert action (by using host variable arrays and the FOR n ROWS form of the INSERT statement).

Related topic

MultiRowInsert-parameters

Multiple row insert actions can provide performance benefits, but they can also increase the overhead of conflict resolution processing when insert-related conflicts occur. Use the MaxRows and MaxConflicts parameters to balance increased performance against increased conflict resolution overhead.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[MultiRowInsert]

Abbreviation

None

Required?

No

Valid values

Yes or No

Default value

No

Usage

Specify Yes to enable multiple-row insert actions. The default value of No causes High-speed Apply Engine to perform single row insert actions for all inserts in the input file.

The performance benefits of multiple row insert actions depend on conditions in your environment. We recommend that you measure results for several values of the MaxRows and MaxConflicts parameters in a test environment before implementing changes in a production environment.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*