From issues-return-15167-archive-asf-public=cust-asf.ponee.io@sentry.apache.org Tue Aug 21 21:07:04 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 9BE79180630 for ; Tue, 21 Aug 2018 21:07:03 +0200 (CEST) Received: (qmail 56173 invoked by uid 500); 21 Aug 2018 19:07:02 -0000 Mailing-List: contact issues-help@sentry.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list issues@sentry.apache.org Received: (qmail 56164 invoked by uid 99); 21 Aug 2018 19:07:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Aug 2018 19:07:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 647C11A254B for ; Tue, 21 Aug 2018 19:07:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -110.301 X-Spam-Level: X-Spam-Status: No, score=-110.301 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id A_Q98EbBxSFr for ; Tue, 21 Aug 2018 19:07:01 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 1ADC65F41B for ; Tue, 21 Aug 2018 19:07:01 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 5E78BE00D3 for ; Tue, 21 Aug 2018 19:07:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 15FB02468F for ; Tue, 21 Aug 2018 19:07:00 +0000 (UTC) Date: Tue, 21 Aug 2018 19:07:00 +0000 (UTC) From: "Arjun Mishra (JIRA)" To: issues@sentry.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (SENTRY-1896) Optimize retrieving entities by other entity types MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/SENTRY-1896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Arjun Mishra updated SENTRY-1896: --------------------------------- Attachment: SENTRY-1896.11.patch > Optimize retrieving entities by other entity types > -------------------------------------------------- > > 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, SENTRY-1896.11.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)