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
Hi Harold,
Just to have a full understanding of the problem, approximately how many items are being returned in your "Changes" tab?
Hello,
You might also check your SQL Compatibility Level. In our customer, we had similar performance issues on Change Tab and the Aras Support proposed us to change the SQL Compatibility Level to 110 as we were with Aras R14.To modify the compatibility level, you may do the following:
- Right-click on the database in SQL Management Studio and select Properties
- Select Options on the left hand side and set 2012 in the Compatibility Level dropdown
Alternatively you may also run the following SQL query against the database to update the compatibility level:
ALTER DATABASE <database_name> SET COMPATIBILITY_LEVEL = 110I will try that, but as I said, it's not the query itself which is slow, unless it's executed in a different way somehow in the odata call than in the "query definition" -> "execute query" action.
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.
