Article - CS53706
Details and structure page of a part loads slowly or publishing of associated CAD document performs poorly in Windchill PDMLink
Modified: 29-May-2025
Applies To
- Windchill PDMLink 10.0 to 12.0
- Windchill MPMLink 10.0 to 12.1
- Windchill Supplier Management 10.0 to 12.1
Description
- Details and structure page of a part loads slowly
- Poor performance to load attributes in Details page
- Details page is slow
- Especially loading the Attributes information
- When using MPMLink details and structure page of a part loads slowly
- Long time execution for BulkIndexing query found in TOP SQL
- Load of part and BOM is very slow in Windchill Bulk Migrator
- Import of WTParts from spreadsheet is taking hours to complete
- Poor performing Windchill Visualization Services publish job where the Job Monitor details show long time spent in Start Store Component Viewable Files:
Aug 24, 2016 12:11:49 PM:Done deleting temporary workspace publish5121846737185629360tmp. Aug 24, 2016 12:11:49 PM:Start Store Component Viewable Files Aug 24, 2016 12:30:13 PM:Retrieving Additional Files
- Related query shows UNION ALL in FROM clause:
SELECT A0.blob$entrySetadHocAcl,A0.classnameA2A2,A0.branchIdA2typeDefinitionRefe,A0.idA3A2ownership,A0.idA2A2, A0.classnamekeydomainRef,A0.securityLabels,A0.entrySetadHocAcl, A0.statestate,A0.idA3domainRef,A0.classnamekeyA2ownership,A0.idA2A2,A0.updateCountA2,A0.classnameA2A2, A0.branchIditerationInfo,A0.branchIdA2typeDefinitionRefe, A1.idA2A2,A1.updateCountA2,A1.classnameA2A2,ABS(NULL),ABS(NULL),A2.idA2A2,A2.updateCountA2, A2.classnameA2A2,ABS(NULL),ABS(NULL),A2.value,A2.wtprecision,A2.idA3A6
FROM WTPart A0,(
SELECT A1.idA2A2,A1.markForDeleteA2,A1.updateCountA2,A1.classnameA2A2 FROM WTPartMaster A1
UNION ALL
SELECT A1.idA2A2,A1.markForDeleteA2,A1.updateCountA2,A1.classnameA2A2 FROM ManufacturerPartMaster A1
) A1, FloatValue / IntegerValue / TimestampValue A2
WHERE ((A0.branchIdA2typeDefinitionRefe = ?))
AND ((A0.markForDeleteA2 = 0)
AND (A1.markForDeleteA2 = 0))
AND ((A0.idA3masterReference = A1.idA2A2)
AND (A2.idA3A4 = A1.idA2A2)
AND (A0.idA2A2 = ?))
This is a printer-friendly version of Article 53706 and may be out of date. For the latest version click CS53706