Click here to Skip to main content
14,937,943 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have created a Procedure to execute the set of queries. In the SQL, the query takes 30sec to execute where as when I call the same procedure in ASP page it takes more time to display the data. Kindly give me a solution for the same.
Posted
Comments
kashif Atiq 23-Feb-12 1:03am
   
if you are displaying data in gridview then that extra time is for rendering data in gridview control. you can implement paging in your stored procedure to cut down data. in that case only small number of records will be returend at time and then gridview will take less time to display them
Arunprasath Natarajan 23-Feb-12 1:18am
   
Thank you.. Hope it works.

1 solution

hi also u can add indexing on the table u Query it will improve ur performance
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900