vb.net webforms datatable filter and sort examples

NJDave71

I am using ASP.NET Web forms and I have created a MSSQL Stored procedure that accepts the parameters and returns the JSON string. The data loads into the Datatables nicely. It takes 7 seconds to return 28,000 records. when I filter the Data it excutes the MSSQL Stored procedure again and it takes 7 seconds or more based on Sorting, Paging and Filtering .

How can I improve my Performance and get a quicker response time?

Thanks