QS version: 3.2 SR 3
QSGC version: 2.1.1
First attempt at trying to get the QS Governance Dashboard working. The qsgc-Refresh-Governance-Dashboard task completed successfully, but took over 7 hours to complete. The bulk of the time was in the following resident load:
2017-10-27 18:36:51 0200 AppTree_tmp:
2017-10-27 18:36:51 0201 Hierarchy(AppTreeNodeId,AppTreeParentNodeId,AppTreeNodeName,'AppTreeParentNodeName',AppTreeNodeName,'AppTreePath','/','AppTreeDepth')
2017-10-27 18:36:51 0202 LOAD
2017-10-27 18:36:51 0203 NodeId as AppTreeNodeId,
2017-10-27 18:36:51 0204 ParentNodeId as AppTreeParentNodeId,
2017-10-27 18:36:51 0205 NodeName as AppTreeNodeName,
2017-10-27 18:36:51 0206 KeyAppTree
2017-10-27 18:36:51 0207 resident AppsTreeStruct
2017-10-27 18:36:51 4 fields found: AppTreeNodeId, AppTreeParentNodeId, AppTreeNodeName, KeyAppTree,
2017-10-27 18:36:51 20,842 lines fetched
2017-10-28 03:04:10 11 fields found: AppTreeNodeName1, AppTreeNodeName2, AppTreeNodeName3, AppTreeNodeName4, AppTreeParentNodeName, AppTreePath, AppTreeNodeId, AppTreeParentNodeId, AppTreeNodeName, KeyAppTree, AppTreeDepth,
2017-10-28 03:04:10 1,404,312,315 lines fetched
2017-10-28 03:04:15 0210 AppTree:
2017-10-28 03:04:15 0211 NoConcatenate
2017-10-28 03:04:15 0212 load *,
Any comments on this runtime? Is this the expected runtime for what it's attempting to do, or is there any way to optimize this area?