Subhrat Chaudhary created RANGER-4907:
-----------------------------------------
Summary: Optimize user delete operation
Key: RANGER-4907
URL: https://issues.apache.org/jira/browse/RANGER-4907
Project: Ranger
Issue Type: Improvement
Components: admin
Reporter: Subhrat Chaudhary
Assignee: Subhrat Chaudhary
If a user has large number of associations with groups, policies, the user
delete operation can take large amount of time, especially while updating the
policies. Since to update a policy, we have large number of validations in
place. This can be even worse, if multiple user delete requests are received at
the same time. We can add following optimizations to improve the user delete
performance:
* Remove foreign key relation of x_user with x_auth_sess, with this we can
skip updating the user references in x_auth_sess when a user is deleted.
* Currently all policy reference for a user are cleaned up and updated ones
are added again. We can remove policy reference only for the user being deleted.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
