[
https://issues.apache.org/jira/browse/RANGER-3051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
fengxianjing updated RANGER-3051:
---------------------------------
External issue URL: https://reviews.apache.org/r/73518/
> 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.0.0, 2.1.0, 2.2.0
> Reporter: fengxianjing
> Assignee: fengxianjing
> Priority: Major
> Attachments:
> 0001-RANGER-3051-resolved-admin-audit-log-query-too-slow.patch
>
>
> 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)
