Skip to content

Comment on Things Developers Should Know About SQL Server (2013)parent

Comments

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.)

AboutSource Built by g1lg1l

Hackerly is an independent reader for Hacker News, built on the public HN API. Not affiliated with Y Combinator.