You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@sentry.apache.org by "Arjun Mishra (JIRA)" <ji...@apache.org> on 2018/04/05 20:18:00 UTC

[jira] [Updated] (SENTRY-1896) Optimize retrieving role names for groups

     [ https://issues.apache.org/jira/browse/SENTRY-1896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Arjun Mishra updated SENTRY-1896:
---------------------------------
    Description: 
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

  was:
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. However, DataNucleus takes too long and the fetch doesn't seem to be lazy. 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


> Optimize retrieving role names for groups
> -----------------------------------------
>
>                 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
>
>
> 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)