Uploaded image for project: 'InsightEdge Platform'
  1. GS-13599

Changed default rownum from 5000 to 10 in Web Management Console

    Details

    • Platform:
      All
    • Sprint:
    • Edition:
      Premium

      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

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: