Click on the link in the Space Tab, query sub-tab for @SpaceClasses
And then users are presented with an editable default query
Default SQL Query has the form:
SELECT UID, * FROM [space class] WHERE rowNum < 5000
If the @SpaceClass comprises as significant portion of the overall database, query causes enough garbage collection to destabilize the grid (re-election of backup as primary leads to over-subscription of CPU resources on VM node that hosts the previous backup and grid does not auto-rebalance).
Use case is:
QA users and developers need to do simple data validation in production rollouts
Usually, they need to evaluate a maximum of a one or a few records (as defined in the SQL WHERE clause).
WEB-UI does not allow unbounded (or otherwise 'destabilizing' queries) against the grid runtime
Set default rownum < 'value', where value is adjusted to 10 (down from 5000)
Provide a WEB-UI configuration that enables a warning message to be provided near the SQLQuery editor that warns the users not to use the queries "unwisely".
Nice to have:
Query Admin API for c = @SpaceClass instance counts.
Calculate average size of @SpaceClass[C]
Calculate total size of query: S = |all C|
If S > "too big", present user with a warning