1.The SP is executed by the SQL server and not by ASP.NET and the execution time is the same on the SQL server;
2.The delay problem is generated by:
i)the amount of data read from the database,
ii)the data transfer of the results over the internet from the web server to the browser.
3.The solution is to use pagination. You could find details and source code (including SP for pagination) in my next article:
Advanced ASPX GridView Pagination and Data Entities[
^]