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 07:06:00 UTC

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

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)