[
https://issues.apache.org/jira/browse/RANGER-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17118935#comment-17118935
]
RickyMa edited comment on RANGER-2789 at 5/28/20, 5:45 PM:
-----------------------------------------------------------
Hey [~pradeep], I retest it. I created 1000 users in my own environment and
found out that it's true that it only took seconds to respond. But it really
took 10+ minutes for Ranger Admin to respond in our customer's environment.
Different VMs, different network conditions, different databases or some other
reasons might have caused this and created this time gap.(I guess it is mainly
because of the databases. Because after my customers applied this patch, the
response time really reduced a lot. And my patch focused on reducing database
queries) With the increasing number of users, it may take longer for Ranger
Admin to respond(Because there will be more database queries). But my patch
just greatly reduced the reponse time as you can see. And I think this patch
will especially help the people with poor performance databases.
was (Author: rickyma):
Hey [~pradeep], I retest it. I created 1000 users in my own environment and
found out that it's true that it only took seconds to respond. But it really
took 10+ minutes for Ranger Admin to respond in our customer's environment.
Different VMs, different network conditions, different databases or some other
reasons might have caused this and created this time gap.(I guess it is mainly
because of the databases. Because after my customers applied this patch, the
response time really reduced a lot.) With the increasing number of users, it
may take longer for Ranger Admin to respond(Because there will be more database
queries). But my patch just greatly reduced the reponse time as you can see.
And I think this patch will especially help the people with poor performance
databases.
> 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)
