[
https://issues.apache.org/jira/browse/CLOUDSTACK-10104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16189386#comment-16189386
]
Pranali Mande commented on CLOUDSTACK-10104:
--------------------------------------------
PR : https://github.com/apache/cloudstack/pull/2282
> Optimize database transactions in ListDomain API to improve performance
> -----------------------------------------------------------------------
>
> Key: CLOUDSTACK-10104
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-10104
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: API
> Reporter: Pranali Mande
>
> While creating the response object for the 'listDomain' API, several database
> calls are triggered to fetch details like parent domain, project limit, IP
> limit, etc. These database calls are triggered for each record found for in
> the main fetch query, which is causing the response to slow down. The
> database transactions could be optimized to reduce the response time of the
> Listdomain API
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)