[RANGER-3051] page /reports/audit/admin is too slow

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.0.0, 2.1.0, 2.2.0
• Component/s: Ranger
• External issue URL: https://reviews.apache.org/r/73518/
• Assignee: fengxianjing
• Reporter: fengxianjing
• Created: 20/Oct/20 07:05
• Updated: 15/Aug/21 06:28

Description

We have millions rows in table x_trx_log, It task me about 1 minute to open this page

The following optimization can solve this problem：

1.Add a column to table x_trx_logto distinguish whether it is the first log

2.  Table building statement of view vx_trx_log change to be like  ..... where (`x_trx_log`.`first` = 1)