fengxianjing created RANGER-3051:
------------------------------------
Summary: page /reports/audit/admin is too slow
Key: RANGER-3051
URL: https://issues.apache.org/jira/browse/RANGER-3051
Project: Ranger
Issue Type: Improvement
Components: Ranger
Affects Versions: 2.1.0, 2.0.0, 2.2.0
Reporter: fengxianjing
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)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
