Question
QML Report
I am using Windchill PDMLink Release 12.1 and Datecode with CPS 12.1.0.2
We intend to extract all relevant information and generate a consolidated file that maps each manufacturer part to its corresponding impacted end part (Commercial Reference Part, i.e., WTPart). Our system currently contains approximately 100,000 manufacturer parts, and this activity will ensure complete traceability and alignment between manufacturer parts and associated WTParts.
While the query performs correctly for individual parts, it does not scale effectively for large datasets.
When executed for the complete dataset of approximately 45000 manufacturer parts, the query requires more than 12 hours and still does not complete the report generation. The performance degradation makes the current approach impractical for production use or recurring data extraction activities.
We intend to extract all relevant information and generate a consolidated file that maps each manufacturer part to its corresponding impacted end part (Commercial Reference Part, i.e., WTPart). Our system currently contains approximately 100,000 manufacturer parts, and this activity will ensure complete traceability and alignment between manufacturer parts and associated WTParts.
While the query performs correctly for individual parts, it does not scale effectively for large datasets.
When executed for the complete dataset of approximately 45000 manufacturer parts, the query requires more than 12 hours and still does not complete the report generation. The performance degradation makes the current approach impractical for production use or recurring data extraction activities.