Click here to Skip to main content
12,254,932 members (63,041 online)
Rate this:
 
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 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 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 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 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160426.1 | Last Updated 20 Jul 2012
Copyright © CodeProject, 1999-2016
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