You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@sentry.apache.org by "Vamsee Yarlagadda (JIRA)" <ji...@apache.org> on 2016/12/08 18:46:59 UTC

[jira] [Created] (SENTRY-1561) Optimize the # of DB calls for the methods in SentryStore

Vamsee Yarlagadda created SENTRY-1561:
-----------------------------------------

             Summary: 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


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)