技术文章 - CS95618
在 Windchill PDMLink 中, 显示对象详细信息页面很慢在使用共享功能的情况下
已修改: 29-May-2018
适用于
- Windchill PDMLink 9.1 to 11.0
说明
- 显示对象详细信息页面很慢
- 系统使用从产品到项目的共享功能
- 下面 SQL 慢引起
SELECT 'wt.inf.sharing.SharedContainerMap',A0.blob$entrySetadHocAcl,A0.classnamekeycontainerReferen,A0.idA3containerReference,A0.creatorRefIsNull,A0.classnamekeyG5,A0.idA3G5,A0.classnamekeydomainRef,A0.idA3domainRef,A0.enabled,A0.entrySetadHocAcl,A0.inheritedDomain,A0.iterationIdIsNull,A0.iterationIdC5,A0.lcState,A0.securityLabels,A0.shareKey,A0.shareType,A0.classnamekeyH5,A0.idA3H5,A0.classnamekeyA5,A0.idA3A5,A0.branchIdA3B5,A0.classnamekeyB5,A0.shortcut,A0.sourceContainerRefIsNull,A0.classnamekeyE5,A0.idA3E5,A0.targetContainerRefIsNull,A0.classnamekeyD5,A0.idA3D5,A0.classnamekeyF5,A0.idA3F5,CONVERT(varchar,A0.createStampA2,120),A0.markForDeleteA2,CONVERT(varchar,A0.modifyStampA2,120),A0.idA2A2,A0.updateCountA2,CONVERT(varchar,A0.updateStampA2,120)
FROM SharedContainerMap A0
WHERE (((A0.idA3A5 = @P1 ) OR (A0.branchIdA3B5 = @P2 ) OR (A0.idA3H5 = @P3 )))
AND (A0.markForDeleteA2 = 0)
FROM SharedContainerMap A0
WHERE (((A0.idA3A5 = @P1 ) OR (A0.branchIdA3B5 = @P2 ) OR (A0.idA3H5 = @P3 )))
AND (A0.markForDeleteA2 = 0)
这是文章 95618 的 PDF 版本，可能已过期。最新版本 CS95618