NAV2013 R2 is about to ship and it contains a bunch of cool new features but one of them I am so entousiastic about I will share it first.
We can, from this release forward, sort on each column in listpages!
Yes, isn't it amazing? And it works in dropdown lists too!
You do not need to add keys to the table to enable this feature
This means that also setcurrentkey can be used without actually defining the key!
This means that if a user sorts on a column on the Item Ledger Entry table without filters and SQL Indexes they can completely clutter your system. Be aware of that!
Other than that, awesome job Microsoft! Thanks.
Love this new feature!
In regards to the performance issue, did you find any way to disable this using code or properties for specific pages?
As far as I know this cannot be disabled.
Should be possible though!