[jira] [Resolved] (RANGER-3023) Permission tab takes longer time to load with large number of users and group_users data

["Mahesh Hanumant Bandal (Jira)" <ji...@apache.org>]

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

Mahesh Hanumant Bandal resolved RANGER-3023.
--------------------------------------------
    Fix Version/s: 3.0.0
       Resolution: Fixed

committed in master branch, commit id : [5732060da4c4c88c1fba3c89fa5369ea56c9b942|https://github.com/apache/ranger/commit/5732060da4c4c88c1fba3c89fa5369ea56c9b942]

> Permission tab takes longer time to load with large number of users and group_users data
> ----------------------------------------------------------------------------------------
>
>                 Key: RANGER-3023
>                 URL: https://issues.apache.org/jira/browse/RANGER-3023
>             Project: Ranger
>          Issue Type: Improvement
>          Components: Ranger
>    Affects Versions: 2.2.0
>            Reporter: Mahesh Hanumant Bandal
>            Assignee: Mahesh Hanumant Bandal
>            Priority: Major
>             Fix For: 3.0.0
>
>
> GET API /service/xusers/permission takes longer time to load with following number of users and group mappings in db.
> {code:java}
> select count(*) from x_user;
> 50052
> select count(*) from x_group_users;
> 500056
> {code}
> Need to have performance optimization on this.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)