MultiRowInsert parameters


The [MultiRowInsert] parameters determine whether the High-speed Apply Engine inserts 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). Additional parameters enable you to control the number of rows in each insert action and to set the level of insert conflicts that High-speed Apply Engine tolerates before it switches to single row insert actions. 

Parameter

Reference

MaxConflicts

MaxRows

MultiRowInsert

The following figure shows an example of the [MultiRowInsert] section:

[MultiRowInsert]
  MultiRowInsert=Yes
  MaxRows=500
  MaxConflicts=5

The [MultiRowInsert] parameters are optional. If you do not specify any of the parameters, High-speed Apply Engine does not perform multiple row insert actions.

 

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