Return-Path: 
 <issues-return-68923-apmail-cloudstack-issues-archive=cloudstack.apache.org@cloudstack.apache.org>
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 BC6CC18093
	for <apmail-cloudstack-issues-archive@www.apache.org>;
 Mon,  4 Apr 2016 06:28:26 +0000 (UTC)
Received: (qmail 81220 invoked by uid 500); 4 Apr 2016 06:28:26 -0000
Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org
Received: (qmail 81195 invoked by uid 500); 4 Apr 2016 06:28:26 -0000
Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@cloudstack.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@cloudstack.apache.org>
List-Post: <mailto:issues@cloudstack.apache.org>
List-Id: <issues.cloudstack.apache.org>
Reply-To: dev@cloudstack.apache.org
Delivered-To: mailing list issues@cloudstack.apache.org
Received: (qmail 81177 invoked by uid 500); 4 Apr 2016 06:28:26 -0000
Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org
Received: (qmail 81169 invoked by uid 99); 4 Apr 2016 06:28:26 -0000
Received: from arcas.apache.org (HELO arcas) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Apr 2016 06:28:26 +0000
Received: from arcas.apache.org (localhost [127.0.0.1])
	by arcas (Postfix) with ESMTP id 348462C1F5D
	for <cloudstack-issues@incubator.apache.org>;
 Mon,  4 Apr 2016 06:28:26 +0000 (UTC)
Date: Mon, 4 Apr 2016 06:28:26 +0000 (UTC)
From: "ASF subversion and git services (JIRA)" <jira@apache.org>
To: cloudstack-issues@incubator.apache.org
Message-ID: <JIRA.12945478.1456755073000.123423.1459751306212@Atlassian.JIRA>
In-Reply-To: <JIRA.12945478.1456755073000@Atlassian.JIRA>
References: <JIRA.12945478.1456755073000@Atlassian.JIRA>
 <JIRA.12945478.1456755073858@arcas>
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=15223721#comment-15223721 ] 

ASF subversion and git services commented on CLOUDSTACK-9298:
-------------------------------------------------------------

Commit 419f8fba63f1fbd46a05d717a9354aad842d6a20 in cloudstack's branch refs/heads/4.9-mvn-upgrade from [~wstevens]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=419f8fb ]

Merge pull request #1425 from nvazquez/listtemplates

CLOUDSTACK-9298: Improve performance of resource retrieval that have tags associated and target volumes, VMs and templatesJIRA TICKET: https://issues.apache.org/jira/browse/CLOUDSTACK-9298

## 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: <code>listTemplates</code>, <code>listVolumes</code>, <code>listVirtualMachines</code>

To achive it, it's necessary to include new columns in <code>template_view</code>, <code>volume_view</code> and <code>user_vm_view</code>:
* tag_account_name
* tag_domain_name
* tag_domain_uuid

* pr/1425:
  CLOUDSTACK-9298: Remove user definer from view creations
  CLOUDSTACK-9298: Add @MappedSuperClass support for persistence inheritance
  CLOUDSTACK-9298: Improve ListTemplatesCmd, ListVolumesCmd and ListVMsCmd performance

Signed-off-by: Will Stevens <williamstevens@gmail.com>


> 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)