large amount of data in the bind in the gridview

Question

0.00/5 (No votes)

See more:

Hello

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

thanks

Posted 5-Aug-14 0:02am

sadhana4

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)

uspatel · Answer 1 · 2014-08-05T00:09:00

Solution 1

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.

Posted 5-Aug-14 0:09am

uspatel

Comments

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.