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

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 3.0.0, 2.3.0
• Component/s: Ranger
• Assignee: Mahesh Hanumant Bandal
• Reporter: Mahesh Hanumant Bandal
• Created: 06/Oct/20 15:18
• Updated: 16/Apr/22 05:24
• Resolved: 03/Nov/21 08:40

Description

GET API /service/xusers/permission takes longer time to load with following number of users and group mappings in db.

select count(*) from x_user;
50052

select count(*) from x_group_users;
500056

Need to have performance optimization on this.

Issue Links

• links to: Apache Review Request