In my web-app I'm using JQuery DataTables plug-in to show data retrieved from database.
I'm currently using client-side pagination, but data in my tables are growing a lot, and loading in ASP.NET pages is now becoming a bit slow. So I was planning to switch to server-side pagination.
I know that DataTables plug-in supports it, but searching around I haven't found notting clear about implementing it.
My main doubt is: if I implement pagination on server-side I also have to implement ordering, or I can delegate it to client-side?
Have you ever experienced this?
NOTE I'm using Linq to SQL to connect to my DB