Click here to Skip to main content
15,671,597 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

large amount of data filling a sql store procedures with 20000 records my gridview with that amount of data takes like 10 minutes
so how to reduce the time to load gridview


1 solution

I would not recommend to retrive all data in one time.
Instead of
You should PAGE your data and only retrieve one page (of fix size, say 50 records per gridview page) of data at a time and show it to the user. That will reduce the aspx page's size and improve the performance as well.
Share this answer
sadhana4 5-Aug-14 8:28am    
ok i already defined paging also
my page size is 50 but it is take time
uspatel 6-Aug-14 2:34am    
I think, you are using default paging but loading whole data in one time.
You should change in query select 50 rows only and on next page click fetch another 50 rows accordingly.

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