Adding family table parts to workspace takes nearly 1 minute

[Aaronm87]

Version: Windchill 12.1

Use Case: Adding parts to workspace takes a long time

Description:

We have some large family tables (~1000 parts). There really isnt a good way to break these apart. It doesn't seem to matter if you select 1 part from the family table for 10, it always takes about a minute to add. It looks like Java is at nearly 100% CPU usage on the performance monitor (I believe this is single core utilization). Does anyone have recommendations on what might be hanging this up or how to investigate further?

[Fadel]

Are you using SQL server as db ?

[Aaronm87]

Yes.

[Fadel]

take a look at https://www.ptc.com/en/support/article/CS327061

https://www.ptc.com/en/support/article/CS157973 

[avillanueva]

I get to share my old content: 😀

https://community.ptc.com/t5/Windchill/Put-your-PDMLink-system-on-a-diet/m-p/482510?search-action-id=163426837589&search-result-uid=482510

https://community.ptc.com/t5/Windchill/My-system-on-a-diet-a-look-back-Part-2/m-p/482600?search-action-id=163426837589&search-result-uid=482600

Yes, despite how many instances you put in workspace, you are paying for the size of the family table. Numbers prove it and while this has gotten significantly better over the releases, its still does some processing across the table. It is possible to break up family tables or reduce their size. We did this years ago but I wonder now if speed improvements have obsoleted this issue.  Something to consider in your 1000+ family tables is are there any sizes that you are not using and are likely never going to use. We removed them but can add back one or two based on user requests. Workspace times improved.