-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/74245/
-----------------------------------------------------------
Review request for ranger, Don Bosco Durai, Abhay Kulkarni, Madhan Neethiraj,
Mehul Parikh, Nikhil P, Pradeep Agrawal, Ramesh Mani, Selvamohan Neethiraj,
Sailaja Polavarapu, Subhrat Chaudhary, and Velmurugan Periasamy.
Bugs: RANGER-3899
https://issues.apache.org/jira/browse/RANGER-3899
Repository: ranger
Description
-------
Analysis is when policy has 500 users with 5 policy items.
we perform total 526 DB read calls and 504 DB write, 3 DB Batch write calls.
This is the reason for policy creation time where 1000 plus DB calls are done
sequentially.
Time is taken to create the policy :4~8 seconds
After Fix :After changing to batch create of XXPolicyRefUser instead of
calling 1 DB write XXPolicyRefUser for every user of the policy:
When Policy contains 500 users,5 access Types (permissions),12 resources
(1DB,1Table,10 columns)
we perform total 526 DB read calls and 6 DB write calls, 5 DB Batch write calls.
Time is taken to create the policy :2.6~4 seconds
Diffs
-----
security-admin/src/main/java/org/apache/ranger/biz/PolicyRefUpdater.java
6cc3509d8
Diff: https://reviews.apache.org/r/74245/diff/1/
Testing
-------
Thanks,
Ramachandran Krishnan
