[jira] [Created] (TRAFODION-2327) Reduce I/O when loading objects into NATable and NARoutine cache

["Roberta Marton (JIRA)" <ji...@apache.org>]

Roberta Marton created TRAFODION-2327:
-----------------------------------------

             Summary: Reduce I/O when loading objects into NATable and NARoutine cache
                 Key: TRAFODION-2327
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2327
             Project: Apache Trafodion
          Issue Type: Improvement
          Components: sql-cmp, sql-security
            Reporter: Roberta Marton
            Assignee: Roberta Marton


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)