Set the hard limit on result sets
This topic describes how to set the hard limit on result sets for a database set.
You can set the hard 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 hard limit as a master property of a database set
Use the installutil setmasterproperty subcommand to set the hard limit as a master property of a database set.
installutil setmasterproperty dbset_name cq_login_id cq_password HARD_QUERY_LIMIT new_value
- Set the hard query limit for the database set
mydbset
to 150,000:installutil setmasterproperty -dbset mydbset admin secret HARD_QUERY_LIMIT 150000
- For the database set
mydbset
, set the hard query limit to 150,000 for theSAMPL
database and 20,000 for theTEST
database:installutil setmasterproperty -dbset mydbset admin secret HARD_QUERY_LIMIT SAMPL=150000;TEST=20000
Set the hard 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\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 Compass\Diagnostic
:HKEY_CURRENT_USER\Software\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"