[RANGER-2713] Remove audit fields from XXPolicyRef objects

• Type: Improvement
• Status: Patch Available
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: master
• Component/s: admin, audit
• Assignee: Unassigned
• Reporter: Andrew Luo
• Created: 28/Jan/20 07:23
• Updated: 24/Feb/23 13:22

Description

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).

Issue Links

• causes: RANGER-2742 Database patch 046 does not apply correctly on SQL Server and SQL Anywhere