[
https://issues.apache.org/jira/browse/SENTRY-1896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16590743#comment-16590743
]
Arjun Mishra commented on SENTRY-1896:
--------------------------------------
New changes. Quick test with 20,000 roles.
{noformat}
Without fix show 20,000 roles- 21.414 sec, 13.496 sec
With fix show 20,000 roles - 3.768 sec, 2.797 sec
{noformat}
> Optimize retrieving entities by other entity types
> --------------------------------------------------
>
> Key: SENTRY-1896
> URL: https://issues.apache.org/jira/browse/SENTRY-1896
> Project: Sentry
> Issue Type: Improvement
> Components: Sentry
> Affects Versions: 2.0.0
> Reporter: Arjun Mishra
> Assignee: Arjun Mishra
> Priority: Major
> Fix For: 2.0.0
>
> Attachments: SENTRY-1896.01.patch, SENTRY-1896.02.patch,
> SENTRY-1896.03.patch, SENTRY-1896.04.patch, SENTRY-1896.05.patch,
> SENTRY-1896.06.patch, SENTRY-1896.07.patch, SENTRY-1896.08.patch,
> SENTRY-1896.09.patch, SENTRY-1896.10.patch, SENTRY-1896.11.patch
>
>
> Right now when we get privileges from sentry, we pass in a provider like set
> of groups. Then we create a MSentryGroup object for each group and then get
> roles using the .getRoles() method. This is bad since we only need the
> roleNames for the group and not the entire Role object.
> Instead running a SQL like query and just getting roleNames will drastically
> improve performance
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
