Setting Mediator Parallel Maximum Rows Retrieved

By increasing the number of rows retrieved from the Mediator store table, performance can be improved in high demand systems.

Getting ready

For more details, refer to the Getting ready section of the Setting Mediator Parallel Metrics Level recipe.

How to do it...

The following steps will allow us to set the Parallel Maximum Rows Retrieved property:

1. Follow the steps from 1 through 3 from the Set Mediator Parallel Metrics Level recipe.

2. Set the property Parallel Maximum Rows Retrieved to a larger value, such as 500.

How it works...

The Parallel Maximum Rows Retrieved property determines how many rows are read from the Mediator store database when loading pending parallel rule execution requests. By loading more rows at a time, the number of trips to the database can be reduced, improving performance; however, this will only have an effect if there are usually multiple requests waiting to be processed. The default is 200 rows, so you will need to have...