Grid Binding with 500000 records

Question

1.18/5 (3 votes)

See more:

hi can any one suggest me how to bind 500000 of records to data grid view without reducing performance.kindly explain with example if possible.

Posted 22-Mar-12 0:45am

brijesh d parikh

Add a Solution

Comments

Afzaal Ahmad Zeeshan 30-Oct-15 17:01pm

Bad programming and UX at its best! :-)

4 solutions

Solution 2

See these may give you some idea

http://forums.asp.net/t/1679972.aspx/1[^]

Optimized Paging and Sorting using Object Data Source[^]

Posted 22-Mar-12 0:57am

sravani.v

Solution 1

use <asp:repeater.. xmlns:asp="#unknown"> data-control & allow paging as your requirement!

Posted 22-Mar-12 0:48am

uttam2010

Updated 22-Mar-12 2:11am

v2

Comments

visnumca123 22-Mar-12 7:15am

Hi uuttam-kumar,I have one question even we fetch the data and binding that in to repeater also it will take time how to avoid the databinding slowness!

[no name] 22-Mar-12 8:30am

You don't. You have been told that 500000 records is way too many. You refuse to use the correct way to do this (pagination) so you are just going to have to deal with it being slow. Seriously, did you really expect that trying to stuff 500K records into anything would be lightning fast?

uttam2010 23-Mar-12 1:31am

you are right Vishu & W.Aday,fetching of 500k records by repeater control without any acceleration(ajax,custom control,Tick event etc) not possible !

Solution 5

Hello:

You have to get records depending of the page number .

Example (50 rows per page):
When you are in the first page.. only get the first block rows (1-50 rows),
When you are in the second page. only get the second block (51-100 rows).

do that and your performance won't be affected

See you..

Posted 30-Oct-15 10:13am

Joshit0

Comments

Matt T Heffron 30-Oct-15 16:55pm

Why are you answering a question that was already answered more than 3 years ago?

CHill60 30-Oct-15 20:34pm

It's a good point, however all you are describing is "lazy loading" that was already proposed as a solution over 3 years ago.
TIP! If you see questions in the QA forum, read them carefully, check the date they were posted, read the solutions already posted. If you can't add something new then avoid posting a solution

Krunal Rohit 31-Oct-15 0:00am

I often wonder how do they get to answer this much old questions ?

-KR

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)

Shahin Khorshidnia · Accepted Answer · 2012-03-22T05:27:00

Solution 3

Hello.

You must follow "Lazy Loading". It can be a useful solution if you want to scroll to much records without any serious problem in performance. In google you are able to search and find many solutions.

For example:

http://www.developer.com/net/asp/article.php/3738616/Lazy-Loading-the-ASPNET-AJAX-TabContainer-Control.htm[^]

http://www.eggheadcafe.com/community/asp-net/17/10395462/gridview-and-lazy-load-plugin.aspx[^]

Posted 22-Mar-12 5:27am

Shahin Khorshidnia

Updated 22-Mar-12 5:33am

v3

Comments

Sergey Alexandrovich Kryukov 22-Mar-12 14:30pm

Very good point. My 5.
--SA

Shahin Khorshidnia 22-Mar-12 14:33pm

Thank you very much SA :)