Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-2327

Reduce I/O when loading objects into NATable and NARoutine cache

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: sql-cmp, sql-security
    • Labels:
      None

      Description

      This is a request to reduce the number of I/O's performed when objects are loaded into caches. Today, the list of roles is read from Metadata every time any object is placed into NATable and NARoutine cache. Since the list of roles associated with the current user is the same independent of the object being referenced, redundant I/O's are performed. The list of roles does change whenever a grant or revoke role is performed against the user, so the solution must make sure grant and revoke operations are handled correctly.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                rmarton Roberta Marton
                Reporter:
                rmarton Roberta Marton
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: