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

Posted to dev@ranger.apache.org by "fengxianjing (Jira)" <ji...@apache.org> on 2020/10/20 08:42:00 UTC

[jira] [Assigned] (RANGER-3051) page /reports/audit/admin is too slow

     [ https://issues.apache.org/jira/browse/RANGER-3051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

fengxianjing reassigned RANGER-3051:
------------------------------------

    Assignee: fengxianjing

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