Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP ASP.NET .NET
Hi,
 
I am having trouble rendering large data to gridview in asp.net c#.
 
I have a gridview where i am rendering data from sql. i have done paging to grid view.
Each page shows 1000 records, with 30 cloumns. Every thing is working fine.
 
I have used stored procedure to get the data, and it is getting the data in 2 sec.
 
The issue is it takes about 2sec to get 1000 record from database, but it is taking 15sec to render and display it on gridview.
 
Is there a faster way to reduce these 15sec rendering time.?
 
Thanks,
Posted 19-Jul-12 21:12pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Don't show 1000 records per page - cut it down to a more managable size for your users.
 
Look at the volume of data you are transferring over the internet: and you are surprised it is slow?
  Permalink  
Comments
Nithin Jadhav at 20-Jul-12 3:26am
   
You are right, i can rather limit page 100 or 500.
But its business requirement to be able to render 1000 record.
 
The same thing works little faster with mozilla browser.
 
I cannot expect all users to use same browser, so i was expecting if there is any other way by which we can improve the rendering speed.
OriginalGriff at 20-Jul-12 3:39am
   
I suspect that it's a data volume problem, so nothing you can really do - and the business requirement is frankly a stupid one. Would you want to wade through a list of 1000 items each page? Or use a search facility on your competitors site? Because I know which site I'd be using in future... :)
Nithin Jadhav at 20-Jul-12 4:13am
   
;-) k. Thanks for sugestions.
 
Our unit has two 8-core Xeon X7560 processors and 128GB of RAM (32x4GB DDR3 DIMMs). For Database Server. Thus they expect, faster speed.
OriginalGriff at 20-Jul-12 4:27am
   
It's not the server speed that is the problem - it's the transfer interface. You can have as fast a processor as you want, but if you are pumping data though a 56K modem it's going to run slow! :laugh: And there are times when the internet behaves like a 56K modem... :(
 
Check your data: you can find free tools to monitor your data I/O which should point up the problem.

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

  Print Answers RSS
0 OriginalGriff 6,649
1 Sergey Alexandrovich Kryukov 6,270
2 CPallini 5,190
3 George Jonsson 3,574
4 Gihan Liyanage 2,522


Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 20 Jul 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100