[
https://issues.apache.org/jira/browse/SENTRY-1937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16163111#comment-16163111
]
Alexander Kolbasov commented on SENTRY-1937:
--------------------------------------------
I didn't run the query, I just run called the function. The test was as
following:
1) Create 2 groups
2) create N roles for the first group and N roles for the second group
3) Call getTSentryRolesByGroupNameOptimized() and compared performance with
getTSentryRolesByGroupName()
The method is used to get roles. This is what is used by Hive to get list of
roles.
> Optimize performance for listing sentry roles by group name
> -----------------------------------------------------------
>
> Key: SENTRY-1937
> URL: https://issues.apache.org/jira/browse/SENTRY-1937
> Project: Sentry
> Issue Type: Improvement
> Components: Sentry
> Affects Versions: 2.0.0
> Reporter: Alexander Kolbasov
> Assignee: Arjun Mishra
>
> It seems that the most common request is listing sentry roles by group name,
> so this is a very hot path. It is important to optimize its performance,
> especially in the presence of many roles.
> [~arjunmishra13] FYI.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
