Compare Features between client side sorting and SQL Server sorting

Question

When it comes to sort some data, we have two option to sort the data: first one is sort on SQL server with ORDER BY clause, and another is Client side sorting ,how i can choose one option over the other and why? which option is more efficient ?what are the feature will help with sorting? is there any sorting function with client side sorting ? what is the adventage on client side sorting?

Does paging come into the mix? That could lock you into sorting on the server. — Mike Cole
– Mike Cole, Commented Mar 2, 2011 at 18:59

Muhammad Akhtar · Accepted Answer · 2011-03-01 06:08:12Z

2

Sorting data in SQL server is faster than client side but getting data from SQL server and binding data to client side will add cost and hence this process more take time than Sorting on client side. I would suggest you to sort data on client side and use some JavaScript framework like Jquery. You have not mention what plateform you are using as front end

Have a look some jquery based sorting example

http://www.codeproject.com/KB/aspnet/TableBlueSorter.aspx

http://www.dotnetcurry.com/ShowArticle.aspx?ID=259

answered Mar 1, 2011 at 6:08

Muhammad Akhtar

52.2k37 gold badges142 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Compare Features between client side sorting and SQL Server sorting

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related