[ 
https://issues.apache.org/jira/browse/CLOUDSTACK-9298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Nicolas Vazquez updated CLOUDSTACK-9298:
----------------------------------------
    Description: 
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

  was:
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
h3. ListTemplatesCmd API method

It is proposed to include tags information into template_view to avoid querying 
the database for each tag, managing that information in memory.


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

Reply via email to