MaxRows

The MaxRows parameter enables you to control how many rows the High-speed Apply Engine includes in each multiple-row insert action of an apply request. Use this parameter to balance the improved performance of multiple row insert actions against the increased overhead that can occur when High-speed Apply Engine must process conflicts and possibly retry the insertion of large numbers of rows.

Related topic

MultiRowInsert-parameters

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[MultiRowInsert]

Abbreviation

None

Required?

No

Valid values

An integer value between 1 and 32,767

Default value

100

Usage

Specify an integer value greater between 1 and 32,767. The default value is 100 rows in each multiple-row insert action.

Be aware of the following points about this parameter:

  • The performance benefits of multiple row insert actions depend on conditions in your environment. We recommend that you measure results for several values of this parameter in a test environment before implementing changes in a production environment.
  • When the insertion of any row during a multiple-row insert action violates a constraint or causes a conflict, High-speed Apply Engine performs the actions defined by the conflict rule in the [InsertConflict] section that specifies a Code value of MultiRowConflict. For more information, see Codes-for-conflict-resolution-SQL-codes.

 

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