Return-Path: X-Original-To: apmail-cloudstack-issues-archive@www.apache.org Delivered-To: apmail-cloudstack-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2683C18D5A for ; Fri, 1 Apr 2016 02:26:26 +0000 (UTC) Received: (qmail 63145 invoked by uid 500); 1 Apr 2016 02:26:26 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 63099 invoked by uid 500); 1 Apr 2016 02:26:26 -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 63085 invoked by uid 500); 1 Apr 2016 02:26:25 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 63079 invoked by uid 99); 1 Apr 2016 02:26:25 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Apr 2016 02:26:25 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id C40A02C1F5D for ; Fri, 1 Apr 2016 02:26:25 +0000 (UTC) Date: Fri, 1 Apr 2016 02:26:25 +0000 (UTC) From: "ASF subversion and git services (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CLOUDSTACK-9298) Improve performance of resource retrieval that have tags associated and target volumes, VMs and templates 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/CLOUDSTACK-9298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15221010#comment-15221010 ] ASF subversion and git services commented on CLOUDSTACK-9298: ------------------------------------------------------------- Commit db54b26fed51d55879f2f704bcfbc25e52e15461 in cloudstack's branch refs/heads/master from [~nvazquez] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=db54b26 ] CLOUDSTACK-9298: Improve ListTemplatesCmd, ListVolumesCmd and ListVMsCmd performance > Improve performance of resource retrieval that have tags associated and target volumes, VMs and templates > --------------------------------------------------------------------------------------------------------- > > Key: CLOUDSTACK-9298 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9298 > Project: CloudStack > Issue Type: Improvement > Security Level: Public(Anyone can view this level - this is the default.) > Components: API > Affects Versions: 4.9.0 > Reporter: Nicolas Vazquez > Fix For: 4.9.0 > > > h2. Description of the problem > When retrieving a large number of resources which have tags associated with, retrieval methods took too long. Our goal is to improve performance of this methods avoiding query the database for each tag, managing that information in memory. > API methods to improve: {{listTemplates}}, {{listVolumes}}, {{listVirtualMachines}} > To achive it, it's necessary to include new columns in {{template_view}}, {{volume_view}} and {{user_vm_view}}: > * tag_account_name > * tag_domain_name > * tag_domain_uuid -- This message was sent by Atlassian JIRA (v6.3.4#6332)