[
https://issues.apache.org/jira/browse/RANGER-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17118960#comment-17118960
]
RickyMa edited comment on RANGER-2789 at 5/28/20, 6:19 PM:
-----------------------------------------------------------
[~pradeep]: I increased the number of users to 10,000 and changed the pageSize
to 10,000. Here is the result:
time curl -s -o /dev/null -X GET -u test:test -H 'Accept:application/json'
'[http://10.1.0.121:6080/service/xusers/users/?pageSize=10000&startIndex=0'|http://10.1.0.121:6080/service/xusers/users/?pageSize=10000&startIndex=0%27]
{code:java}
real 7m10.208s
user 0m0.010s
sys 0m0.017s
{code}
time curl -s -o /dev/null -X GET -u test:test -H 'Accept:application/json'
'http://10.1.0.121:6080/service/xusers/users/?pageSize=10000&startIndex=0'
{code:java}
real 0m3.115s
user 0m0.006s
sys 0m0.014s
{code}
As you can see, the perfermance increased a lot.
was (Author: rickyma):
[~pradeep] I increased the number of users to 10,000 and changed the pageSize
to 10,000. Here is the result:
time curl -s -o /dev/null -X GET -u test:test -H 'Accept:application/json'
'[http://10.1.0.121:6080/service/xusers/users/?pageSize=10000&startIndex=0'|http://10.1.0.121:6080/service/xusers/users/?pageSize=10000&startIndex=0%27]
{code:java}
real 7m10.208s
user 0m0.010s
sys 0m0.017s
{code}
time curl -s -o /dev/null -X GET -u test:test -H 'Accept:application/json'
'http://10.1.0.121:6080/service/xusers/users/?pageSize=10000&startIndex=0'
{code:java}
real 0m3.115s
user 0m0.006s
sys 0m0.014s
{code}
As you can see, the perfermance increased a lot.
> GET API service/xusers/users turns very slow when there are more than 1000
> users
> --------------------------------------------------------------------------------
>
> Key: RANGER-2789
> URL: https://issues.apache.org/jira/browse/RANGER-2789
> Project: Ranger
> Issue Type: Bug
> Components: Ranger
> Affects Versions: 2.0.0
> Environment: hdp 2.2
> Reporter: RickyMa
> Priority: Minor
> Labels: optimization, performance, ranger, rangeradmin, slow
> Attachments: RANGER-2789.patch, image-2020-04-10-19-37-31-570.png
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> We have more than 1000 users in production environment.
> When calling API 'service/xusers/users?pageSize=1000&startIndex=0' using HTTP
> GET method, Ranger Admin takes 10+ minutes to response.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
