News for hackers. Stuff that matters.
Re:Things Developers Should Know About SQL Server (2013) by olavk on Sunday February 12, 2017 @12:35PM (#13629406)
It doesn't take more bandwidth to transfer unsorted than sorted data, and the memory cost will presumably be the same for sorting on the server as on the client. Filtering should always happen in the database for the sake of bandwidth and performance, but this doesn't apply to sorting the resultset since sorting doesn't change the amount of data.

(Unless the sorting is an intermediate step before further filtering, in which case the advice obviously does not apply.)

There are no comments on this comment yet.