[CLOUDSTACK-9298] Improve performance of resource retrieval that have tags associated and target volumes, VMs and templates

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.9.0
• Fix Version/s: 4.9.0
• Component/s: API
• Security Level: Public (Anyone can view this level - this is the default.)
• Flags: Patch
• Assignee: Unassigned
• Reporter: Nicolas Vazquez
• Created: 29/Feb/16 14:11
• Updated: 04/Aug/16 18:22
• Resolved: 04/Aug/16 18:22

Description

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