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 = 110
I 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.
