Performance issue when upgrading from is MS SQL Server 2012 to 2016
When I load a data in a grid in when the has a simple Xpath [attritute != empty] and [entity1/entity2/entity3 = '[%CurrentObject%]'], the performance downgrade from second using MSQL 2012 to more than 5 minutes using 2016. When we removed the second part of the condition It’s performing well. When I change the compatibility mode back to MSQL 2012 it works fine again.
I recommend that you submit this to Mendix Support.