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 cust-asf.ponee.io (Postfix) with SMTP id 82BDE160C15 for ; Wed, 3 Jan 2018 10:08:04 +0100 (CET) Received: (qmail 11971 invoked by uid 500); 3 Jan 2018 09:08:03 -0000 Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list issues@cloudstack.apache.org Received: (qmail 11962 invoked by uid 500); 3 Jan 2018 09:08:03 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 11959 invoked by uid 99); 3 Jan 2018 09:08:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Jan 2018 09:08:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id DF42F180146 for ; Wed, 3 Jan 2018 09:08:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -107.211 X-Spam-Level: X-Spam-Status: No, score=-107.211 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_NONE=-0.0001, SPF_PASS=-0.001, T_RP_MATCHES_RCVD=-0.01, 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 (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id jOmcky21kr1L for ; Wed, 3 Jan 2018 09:08:02 +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 8081F5F2F0 for ; Wed, 3 Jan 2018 09:08: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 7E67CE023C for ; Wed, 3 Jan 2018 09:08: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 33B9E212F7 for ; Wed, 3 Jan 2018 09:08:00 +0000 (UTC) Date: Wed, 3 Jan 2018 09:08:00 +0000 (UTC) From: "ASF GitHub Bot (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CLOUDSTACK-10065) Optimize SQL queries in listTemplate API to improve performance. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 03 Jan 2018 09:08:05 -0000 [ https://issues.apache.org/jira/browse/CLOUDSTACK-10065?page=3Dcom.atl= assian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId= =3D16309331#comment-16309331 ]=20 ASF GitHub Bot commented on CLOUDSTACK-10065: --------------------------------------------- blueorangutan commented on issue #2260: CLOUDSTACK-10065: Optimize SQL quer= ies in listTemplate API to improve performance URL: https://github.com/apache/cloudstack/pull/2260#issuecomment-354964582 =20 =20 Packaging result: =E2=9C=94centos6 =E2=9C=94centos7 =E2=9C=94debian. JID= -1552 ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. =20 For queries about this service, please contact Infrastructure at: users@infra.apache.org > Optimize SQL queries in listTemplate API to improve performance.=20 > ----------------------------------------------------------------- > > Key: CLOUDSTACK-10065 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-100= 65 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the defa= ult.)=20 > Reporter: Pranali Mande > > *Description*: > The db queries could be optimized to get unique results from the database= which could help in reducing the listTemplate API response time. -- This message was sent by Atlassian JIRA (v6.4.14#64029)