BindTuning parameters
The following figure shows an example of the [BindTuning] parameters.
Synchronous=YES
MaxPackages=3
MaxFailedBinds=5
MaxRetries=2
StatementCount=200
StatementUsage=50
High-speed Apply Engine provides two basic groups of [BindTuning] parameters:
Limits on bind actions for static SQL
This group determines how High-speed Apply Engine binds static SQL and when it stops binding static SQL. The group includes the MaxFailedBinds, MaxRetries, and Synchronous parameters. For more information, see the individual parameter descriptions that are included in this section.
Performance of bind actions for static SQL
This group enables you to influence the frequency of bind actions, the size of bound packages, and the overall balance between static SQL and other methods (dynamic SQL with prepared statements and EXECUTE IMMEDIATE). This group includes the MaxPackages, PackageUsage, StatementCount, and StatementUsage parameters.
When you adjust one parameter, consider the values of the others. Because these parameters are used together, the following paragraphs contain information about their interaction.
This section contains the following topics: