Click here to Skip to main content
11,639,922 members (61,040 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: C# ASP ASP.NET .NET

I am having trouble rendering large data to gridview in 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.?

Posted 19-Jul-12 21:12pm

1 solution

Rate this: bad
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?
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 Suvendu Shekhar Giri 330
1 CPallini 177
2 F-ES Sitecore 170
3 sasanka sekhar panda 155
4 142
0 OriginalGriff 9,081
1 Sergey Alexandrovich Kryukov 8,847
2 Mika Wendelius 7,027
3 Suvendu Shekhar Giri 2,650
4 F-ES Sitecore 2,558

Advertise | Privacy | Mobile
Web03 | 2.8.150731.1 | Last Updated 20 Jul 2012
Copyright © CodeProject, 1999-2015
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