how to bind 12 to 20 millions records into gridview(without paging) within 5 minutes

Question

1.00/5 (3 votes)

See more:

, +

Hi,

I am binding GridView with dataset of 12 millions of records with 18 columns. I use different cases(without paging)
Case1:-a grid with Autogenerated columns False. (I generate 18 columns inside gridview) Time taking to load 45 minutes.
Case2:- Geneare a grid with Autogenerated columns True. Directly assigning DataSource property and DataBind to Gridview Control.
Time taking to load 60 minutes.

Please tell me how to reduce the time for loading. I am using this .aspx page for showing the report data.
please share any idea and solution to me.

Posted 21-Aug-14 19:34pm

krish2013

Updated 21-Aug-14 19:55pm

chaau

v6

Add a Solution

Comments

[no name] 22-Aug-14 6:16am

You would still need to change the laws of physics.

Per Söderlund 22-Aug-14 8:20am

What are you going to do when you have populated the grid?
Are you going to read it or will someone else do it?
Why do you need to show that much data?

krish2013 25-Aug-14 3:35am

Hii Soderlund,
Thanks for reply to me.i want only display 20 lakhs records only.please share any idea or information to me.

2 solutions

Solution 2

You must use pagination, especially because is a web application and you have a huge amount of data! I have an article about this subject, where I explained why you need this, and there you could find also source code.
Advanced ASPX GridView Pagination and Data Entities[^]

Posted 21-Aug-14 19:53pm

Raul Iloc

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 · Accepted Answer · 2014-08-21T19:53:00

As you were told last time you posted this question: how to bind 12 to 20 lakhs records into gridview within fraction of seconds[^] (and deleting questions because you don't like the answer is rude)
That is a very stupid idea.

For anyone else that is reading, 2,000,000 rows of data in a single control is stupid: it will take a user days to find the info he wants.
Add to that the transfer time to move 2,000,000 rows of 18 columns of data over a "normal" broadband connection and it can't be done in 5 minutes, even if the database server could feed the data instantaneously to the webserver, and the browser took no time at all to render the page.

Please stop posting the same question, sit down, and do the job properly: you cannot do this, it will not work.