[RANGER-3027] Improve response time for GET API service/xusers/users

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.2.0
• Fix Version/s: 3.0.0, 2.2.0
• Component/s: Ranger
• Assignee: Unassigned
• Reporter: Mahesh Bandal
• Created: 07/Oct/20 14:12
• Updated: 10/Aug/23 07:38

Description

When there are large number of users and group_users data in database; GET API service/xusers/users takes longer time to respond if we set request parameter pageSize=1000  or more.

However, with default value pageSize=25 response received instantaneously.

select count(*) from x_user;
50052

select count(*) from x_group_users;
500056

Issue Links

• is a clone of: RANGER-2789 GET API service/xusers/users turns very slow when there are more than 1000 users
• relates to: RANGER-3014 fix for RANGER-2789 breaks current functionality
• links to: Pull Request
• links to: Review request