I had a discussion with a colleague about sorting data from the database, he is of the opinion that it is better to do the sorting on the client side, for better server performance. How valid is the argument? How would you handle this?
I think it's better to do in the server side, because of the power of the machine and maybe the language you use fit's more for this need.
Mario Giambanco
Director of User Experience Development
Both.
If I wanted a list of users, I might want to sort it by the registration date; or by paid vs not paid. If I wanted a list of events, I might sort it by event date or # of attendees. So I would do an initial sort of the data on the server in the way I feel the data is best sorted.
Then, if the user wants to sort the data a different way; say, sort the attendees of an event alphabetically - that'll be the client side sort.