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 theSAMPL
database and 20,000 for theTEST
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"