TreeGridView performance
We have "changes" tab to list, in a tree grid view, the change objects which have gone through on a given Part. However, loading this tab is terribly slow.
I have found out that the query itself...
Forum Discussion
It takes ~15 seconds even if there are none, but it can be maybe a couple of hundred at most.
I can´t really help in this discussion, but I very much like the topic. Is the rendering slow for every user? Cause I right now face a similar scenario with 2 of my users were Innovator is very slow. Mainly Impact Matrix, but also trivial elements like the make/buy Form dropdown.
Are other TGVs slow too? The Changes tab is a bit of a unicorn, cause it´s a very complex rendering with an unique structure. From my POV it´s the slowest one in general. I made a quick test: 4-5 seconds for around 10 Changes / 3 different CM types used. It´s ok, but other TGVs are much faster.
A few years ago I also changed the compatibility level, but mainly so I can use more modern SQL functions like STRING_SPLIT which weren´t supported by the previous 2012r2 server. It´s definitely a good tip, even if it doesn´t improve the TGV situation.
