When the datasource have 20 thousand rows of data,the speed to show it is so slow?How to improve the speed to show it?

Question

4.00/5 (2 votes)

See more:

, +

My code is gridview.datasource=a (a is list<studeng> whcih has 20 thousand ),the speed is so slow;
my idea is when user firstly enter the web page , I set gridview.datasource=a1 (a1 is the first 1 thousand rows of data in a);
and than I set gridview.datasource=a1 (a1 is the first 2 thousand rows of data in a);
....
and than I set gridview.datasource=a19 (a1 is the first 19 thousand rows of data in a);
and than I set gridview.datasource=a20 (a1 is the first 20 thousand rows of data in a);

but it seems doesn't work, how to solve it ?

Can you give me some example to use gridvie to show large amount of data quick in a web page?Thank you!

Posted 7-Aug-12 7:44am

PEIYANGXINQU

Add a Solution

Comments

lewax00 7-Aug-12 14:13pm

Is it slow on the machine hosted the server (e.g. when you debug it locally), or just when someone loads it remotely? Because if it's the latter then there isn't much you can do, a lot of data being displayed means a lot of data has to be transferred, and that takes time based on your network connection.

PEIYANGXINQU 7-Aug-12 14:17pm

Both, I think we can optimize this.

[no name] 7-Aug-12 14:22pm

It's called paging. Besides that, no one is going to look at 20K rows of data. No reason at all to be doing that to begin with.

3 solutions

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)

lewax00 · Answer 1 · 2012-08-07T08:37:00

You should probably use the built in paging features of the GridView class (see this example[^])

That's a lot of data for a web page, think about it:
Let's assume you only have one column, each entry empty, and the encoding is UTF-8
The GridView will generate a table, each row needs "<tr>" and "</tr>" (9 bytes), and each item needs "<td>" and "</td>" (9 bytes), so:
20000 * (9 bytes per row + 1 item per row * 9 bytes per item) = 360,000 bytes, just for the markup with one column. But your data probably has more columns, and the values of your entries each add to that data. That's a lot of data to transfer all at once, and it will be slow. If you page it, you only have to send them a little at a time, and it will be much faster.

Kenneth Haugland · Answer 2 · 2012-08-07T08:21:00

Solution 1

There is code for this in WPF, you should however be able to translated it to Silverlight without big issues:
http://bea.stollnitz.com/blog/?p=344[^]

Posted 7-Aug-12 8:21am

Kenneth Haugland

Leo Rajendra Dhakal · Answer 3 · 2012-08-15T23:35:00

Solution 3

the best option is paging which loads minimum pages records only as a result pages load fast, it ignore large numbers of data.

Posted 15-Aug-12 23:35pm

Leo Rajendra Dhakal