[
https://issues.apache.org/jira/browse/SENTRY-1561?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vamsee Yarlagadda updated SENTRY-1561:
--------------------------------------
Description: As part of SENTRY-1557, we handled the DB roundtrips for some
of the functions like getRolesForGroups, getRolesForUsers. On the same lines,
we should revisit the entire class and optimize (if possible) on the # of DB
calls being made. (was: The function getRolesForGroups() does a SELECT query
for each group in the input set. Instead it should do one of the following:
1) A single SELECT with OR for all groups
2) Just fetch all groups and filter in-memory.)
> Optimize the # of DB calls for the methods in SentryStore
> ----------------------------------------------------------
>
> Key: SENTRY-1561
> URL: https://issues.apache.org/jira/browse/SENTRY-1561
> Project: Sentry
> Issue Type: Improvement
> Components: Sentry
> Affects Versions: 1.8.0, sentry-ha-redesign
> Reporter: Vamsee Yarlagadda
> Assignee: Vamsee Yarlagadda
> Priority: Minor
> Labels: bite-sized
>
> As part of SENTRY-1557, we handled the DB roundtrips for some of the
> functions like getRolesForGroups, getRolesForUsers. On the same lines, we
> should revisit the entire class and optimize (if possible) on the # of DB
> calls being made.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
