Question

Performance of database retrieves with sort versus retrieve by association and then list sort?

0

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?

asked 2023-02-25

Ron de Vries

1 answers

Tim van Steenbergen · Accepted Answer · 2023-02-25

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.