db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3906) SQL roles: add caching of the role grant graph for performance
Date Fri, 10 Oct 2008 00:40:44 GMT
SQL roles: add caching of the role grant  graph for performance
---------------------------------------------------------------

                 Key: DERBY-3906
                 URL: https://issues.apache.org/jira/browse/DERBY-3906
             Project: Derby
          Issue Type: Improvement
          Components: SQL
            Reporter: Dag H. Wanvik
            Priority: Minor


In the first implementation, the graph of the grant role relation is built as needed.
For DDL statements this is acceptable, but less less so for the following case:

When a session changes it's role from a non-null role ("old role"), any activations
of prepared statements that relied on a role in "old role"s grant closure will need re-checking.
So, computing this, requires the grant graph. Setting a role is a more frequent operations,
e.g. in a stored routine, so re-building the grant graph each time is (too) expensive.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message