[RANGER-3024] Improve response time and refactor code for GET API /service/xusers/lookup/users

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 3.0.0, 2.2.0
• Component/s: Ranger
• Assignee: Mahesh Hanumant Bandal
• Reporter: Mahesh Hanumant Bandal
• Created: 06/Oct/20 15:37
• Updated: 02/Aug/21 11:46
• Resolved: 02/Aug/21 11:46

Description

GET API /service/xusers/lookup/users returns List of String object which contains username. But it also traverse through groupUser list while populating view object VXUser. When there are large number of users and group_users data in database; it takes longer time to respond if we set request parameter pageSize=1000  or more. This causes performance issue and needs to be improved.

select count(*) from x_user;
50052

select count(*) from x_group_users;
500056