query only the pagesize but be able to page through all the records

gnop

So i am new to jquery and javascript in general, but i am using ASP.NET MVC, and right now im loading all the records into a table and dataTables converts the DOM. But the problem with this is that the query is taking way too long to finish, so i want to change the query so it only returns the amount of rows per page then when you change pages it will requery those specific rows. The query i created works but of course i want to be able to page and sort through all of the rows from the table and not just the records that were loaded.
Does anyone have any ideas on how i can accomplish this?

Thanks