Speed rendering large data in gridview in ASP .net c#

Question

0.00/5 (No votes)

See more:

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

Nithin Jadhav

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2012-07-19T21:15:00

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?

Posted 19-Jul-12 21:15pm

OriginalGriff

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.