We're updating the issue view to help you get more done. 

Changed default rownum from 5000 to 10 in Web Management Console

Description

Users can:

  • 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).

Requirements:

  • WEB-UI does not allow unbounded (or otherwise 'destabilizing' queries) against the grid runtime

Suggested fix:

  • 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

Workaround

None

Acceptance Test

None

Status

Assignee

Meron Avigdor

Reporter

Jason Nerothin

Labels

Priority

Medium

SalesForce Case ID

None

Fix versions

Commitment Version/s

None

Due date

None

Product

None

Edition

Premium

Platform

All