[
https://issues.apache.org/jira/browse/SENTRY-1557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vamsee Yarlagadda updated SENTRY-1557:
--------------------------------------
Resolution: Fixed
Fix Version/s: sentry-ha-redesign
1.8.0
Status: Resolved (was: Patch Available)
master: ff623a9444a711ddcf3b8ed558530709ddbf0623
sentry-ha-redesign: 7c345602033dcad6f6470d2b990aeeaf49fd630e
[~akolb], [~kkalyan]- Thanks for the review.
> getRolesForGroups() does too many trips to the the DB
> -----------------------------------------------------
>
> Key: SENTRY-1557
> URL: https://issues.apache.org/jira/browse/SENTRY-1557
> Project: Sentry
> Issue Type: Improvement
> Components: Sentry
> Affects Versions: 1.8.0, sentry-ha-redesign
> Reporter: Alexander Kolbasov
> Assignee: Vamsee Yarlagadda
> Priority: Minor
> Labels: bite-sized
> Fix For: 1.8.0, sentry-ha-redesign
>
> Attachments: SENTRY-1557.patch, SENTRY-1557.v2.patch,
> SENTRY-1557.v3.patch
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
