Unique Key Checks

Tip

Specify whether the Rules Engine must perform Unique Key Checks.

Background

The Unique Key Check additional parameter is used to determine whether the Rules Engine must perform unique key checks in the case of non-manual data entry, for example sql-script() functions. Allowed values are:

·	True (the default)

False

If this parameter is set to True, error feedback will be faster.

If it is set to False, performance will be slightly better in the case of non-manual data entry, for example sql-script() functions. In this case, unique key checks are still performed by the RDBMS so that data integrity is ensured. For data entered manually, unique key checks continue to be performed by the Rules Engine.

When to use

Set this parameter to False only in time-critical situations where overall performance is a real issue.

To turn off Unique Key Checks:

1.	Open the Authorizer.

2.	In the Deployment Configurations window, select the Configuration for which you want to turn off Unique Key Checks.

Usually this will be the LAN configuration.

3.	Check the Changeable check box. Now you can change this deployment configuration.

4.	One of the Additional Parameters at the On Line tab page reads Unique_Key_Check. Change the value of this parameter to False.

5.	Save your changes.