Performance of database retrieves with sort versus retrieve by association and then list sort?
Hi Guru’s, A somewhat lazy question (as I guess I could try to time this out as well :-) ). Does anyone know what the performance difference is between doing a retrieve by database and then sorting during that action versus doing a retrieve by association and then sorting the list after with a list operation? Is there specific best practice guidance between the two?
Ron de Vries
None. The MBS (Mendix Business Server) does tend to be smart enough to group two activities (the retrieve and the sort-list) together as one database-statement and will therefor have the same performance as the sorting retrieve activity. Same as Retrieve followed by List Count.