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 00724184E5 for ; Fri, 11 Mar 2016 10:20:15 +0000 (UTC) Received: (qmail 87928 invoked by uid 500); 11 Mar 2016 10:20:14 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 87895 invoked by uid 500); 11 Mar 2016 10:20:14 -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 87882 invoked by uid 500); 11 Mar 2016 10:20:14 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 87878 invoked by uid 99); 11 Mar 2016 10:20:14 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Mar 2016 10:20:14 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 75B142C1F5D for ; Fri, 11 Mar 2016 10:20:14 +0000 (UTC) Date: Fri, 11 Mar 2016 10:20:14 +0000 (UTC) From: "ASF GitHub Bot (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=15190766#comment-15190766 ] ASF GitHub Bot commented on CLOUDSTACK-9298: -------------------------------------------- Github user nvazquez commented on the pull request: https://github.com/apache/cloudstack/pull/1425#issuecomment-195308535 @rafaelweingartner it was my mistake, I had writen user_vm__view instead of user_vm_view on the script. I fixed it and pushed again > 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)