[ 
https://issues.apache.org/jira/browse/CLOUDSTACK-9298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15202050#comment-15202050
 ] 

ASF GitHub Bot commented on CLOUDSTACK-9298:
--------------------------------------------

Github user nvazquez commented on the pull request:

    https://github.com/apache/cloudstack/pull/1425#issuecomment-198518585
  
    Hi @rafaelweingartner, I also ran 
<code>test/integration/smoke/test_templates.py</code>, I post its results:
    
    ````
    [root@ussarlabcsmgt41 cloudstack]# cat 
/tmp/MarvinLogs/test_templates_LRM26P/results.txt
    Test create public & private template ... === TestName: 
test_01_create_template | Status : SUCCESS ===
    ok
    Test when createTemplate is used to create templates having the same name 
all of them get ... === TestName: test_CreateTemplateWithDuplicateName | Status 
: SUCCESS ===
    ok
    Test Edit template ... === TestName: test_02_edit_template | Status : 
SUCCESS ===
    ok
    Test delete template ... === TestName: test_03_delete_template | Status : 
SUCCESS ===
    ok
    Test for extract template ... === TestName: test_04_extract_template | 
Status : SUCCESS ===
    ok
    Update & Test for template permissions ... === TestName: 
test_05_template_permissions | Status : SUCCESS ===
    ok
    Test for copy template from one zone to another ... SKIP: Not enough zones 
available to perform copy template
    Test only public templates are visible to normal user ... === TestName: 
test_07_list_public_templates | Status : SUCCESS ===
    ok
    Test System templates are not visible to normal user ... === TestName: 
test_08_list_system_templates | Status : SUCCESS ===
    ok
    
    ----------------------------------------------------------------------
    Ran 9 tests in 5671.295s
    
    OK
    ````


> 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