Set the soft limit on result sets

This topic describes how to set the soft limit on result sets for a database set.

You can set the soft query limit as a master property of a Compass database set, or by setting a behavior flag in the local environment where the Compass core resides. Locally defined hard and soft query limits override the master property values set in the database set.

Set the soft limit as a master property of a database set

Use the installutil setmasterproperty subcommand to set the soft limit as a master property of a database set.

installutil setmasterproperty dbset_name cq_login_id cq_password SOFT_QUERY_LIMIT new_value

Examples

Set the soft limit for the database set mydbset to 150,000:

installutil setmasterproperty -dbset mydbset admin secret SOFT_QUERY_LIMIT 150000

For the database set mydbset, set the soft limit to 150,000 for the SAMPL database and 20,000 for the TEST database:
```
installutil setmasterproperty -dbset mydbset admin secret SOFT_QUERY_LIMIT SAMPL=150000;TEST=20000
```

Set the soft limit by using a behavior flag in the local environment

To set the query limit behavior flags in the local environment where the Compass core resides, either modify the Windows™ Registry key HKEY_CURRENT_USER\Software\HCL Compass\Diagnostic, or set the environment variable CQ_DIAG_BEHAVIOR.

Examples

Set the soft limit to 5,000 and the hard limit to 20,000 by modifying the Windows Registry.
Use regedit to modify the Registry key HKEY_CURRENT_USER\HCL\CCM\Compass\Diagnostic:
```
HKEY_CURRENT_USER\HCL Compass\Diagnostic
"Name"=""
"behavior"="SOFT_QUERY_LIMIT=5000;HARD_QUERY_LIMIT=20000"
```
Set the soft limit to 5,000 and the hard limit to 20,000 by setting the environment variable CQ_DIAG_BEHAVIOR.
```
CQ_DIAG_BEHAVIOR="SOFT_QUERY_LIMIT=5000;HARD_QUERY_LIMIT=20000"
```