[
https://issues.apache.org/jira/browse/CLOUDSTACK-7981?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14227123#comment-14227123
]
Min Chen commented on CLOUDSTACK-7981:
--------------------------------------
we should not join user_vm_details table in user_vm_view at all since our code
never used them, we always find details from user_vm_details table directly.
Also, handle duplicate resource tag entry by avoiding retrieving duplicate tags.
> listVirtualMachine is too slow in case of duplicate resource tags due to
> joining user_vm_details to user_vm_view
> ----------------------------------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-7981
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-7981
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: API
> Affects Versions: 4.2.1
> Reporter: Min Chen
> Assignee: Min Chen
> Priority: Critical
> Fix For: 4.5.0
>
>
> Deploy 40 to 50 VMs, each one has 3-4 resource tags, and each one also add
> about 10 details, then do a listVMCmd, the performance is very slow.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
