You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ranger.apache.org by "Andrew Luo (Jira)" <ji...@apache.org> on 2023/02/08 16:21:00 UTC

[jira] [Commented] (RANGER-2713) Remove audit fields from XXPolicyRef objects

    [ https://issues.apache.org/jira/browse/RANGER-2713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17685971#comment-17685971 ] 

Andrew Luo commented on RANGER-2713:
------------------------------------

https://reviews.apache.org/r/74301/

> Remove audit fields from XXPolicyRef objects
> --------------------------------------------
>
>                 Key: RANGER-2713
>                 URL: https://issues.apache.org/jira/browse/RANGER-2713
>             Project: Ranger
>          Issue Type: Improvement
>          Components: admin, audit
>    Affects Versions: master
>            Reporter: Andrew Luo
>            Priority: Minor
>         Attachments: 0001-RANGER-2713-Remove-audit-fields-from-XXPolicyRef-obj.patch
>
>
> XXPolicyRef objects have fields such as create time, update time, added by user ID, updated by user ID, but there fields are entirely useless since they are all copied from the XXPolicy object.  In addition, while improving performance for creation of policies with large numbers of users, we discovered that a lot of time was being spent in JPA converting these Date objects especially.  After removing these fields we saw a significant performance improvement (a secondary benefit is less database space usage).



--
This message was sent by Atlassian Jira
(v8.20.10#820010)