Check the SQL that is running on the server. If you’ve got relations and shortcuts these are being evaluated all the way down the relationship chain.However, there are 2 areas I would love to see improvements.
1. Speed. There are many times I use a stored procedure because queries that join to multiple tables are a little slower in Aware. It could be the amount of traffic that aware returns (Seems to be all the columns in a table). This is way above my pay grade, but perhaps if my custom app was compiled as a Java bean it would run faster.
The new Resolve Shortcut flag can be used to enhance the speed by not evaluating the chain of the shortcut.