[jira] [Updated] (RANGER-3447) Ranger startup optimization: reduce number of DB queries to read service-defs

["Madhan Neethiraj (Jira)" <ji...@apache.org>]

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

Madhan Neethiraj updated RANGER-3447:
-------------------------------------
    Attachment: RANGER-3447.patch

> Ranger startup optimization: reduce number of DB queries to read service-defs
> -----------------------------------------------------------------------------
>
>                 Key: RANGER-3447
>                 URL: https://issues.apache.org/jira/browse/RANGER-3447
>             Project: Ranger
>          Issue Type: Improvement
>          Components: Ranger
>            Reporter: Madhan Neethiraj
>            Assignee: Madhan Neethiraj
>            Priority: Major
>         Attachments: RANGER-3447.patch
>
>
> While reading service-def from DB, a DB query is executed for each access-type defined in the service-def to retrieve impliedGrants. This results in read time to increase for service-defs having large number of access-types. This can be optimized by loading impliedGrants for all access-types in a single DB query.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)