handling large dataset in gridview?

Question

4.00/5 (1 vote)

See more:

SQL-Server-2005

, +

Hello sir

i have gridview with 25000 records i use sessions for searching sorting paging everything and also remembering last action but my page is getting infinite loop all is working fine but i dont have any idea or sequence where i am sticking so please give me some links or any code from that i can make my gridview faster handling larger dataset.....

thanks in advance..

scenario
[updated]
gridview

>by default 25000 records will be shown with page size 25 and then paging......

>there is 10 fields image,productname,saleprice,active edit and delete button on click of edit user will redirected to another page
>
now paging will be like this if user on 1st page change sale price then goes to 2 page again to 1 page updated price should be remains updated
>
while page is refresh page searched record sorted record updated record paged record should be stay same as was before....

Posted 25-Aug-13 20:00pm

Dholakiya Ankit

Updated 27-Aug-13 18:37pm

v6

Add a Solution

Comments

Thanks7872 26-Aug-13 2:20am

gridview with 25000 records? Oh...!!

make my gridview faster ?

Dholakiya Ankit 26-Aug-13 2:22am

yes i want some technique for making it faster

Thanks7872 26-Aug-13 2:23am

Do you consider GridView with 25000 records as a good practice?

Dholakiya Ankit 26-Aug-13 2:24am

no but i dont have any other choice do you have?

Thanks7872 26-Aug-13 2:26am

Why not other choice? You explained that you are going to provide search functionality. That is you are filtering data some way,then why not to filter it while binding it with gridview? If i give you 25000 records,would you like to go through that much records? No body will.

Dholakiya Ankit 26-Aug-13 2:28am

then give me some idea about this i am stuck in it i also have functionality like
if user changed textbox value in page 1 and goes to 2 one afer first one then changed value of page 1 should comes back.....this is only 1 functionality of it

Thanks7872 26-Aug-13 2:33am

Let me explain. Suppose you have 25000 records of company for all the employee,then you can have option to select employee as well,after that select dates etc. This way,you are omitting unnecessary results. If i want to search for Ankit's record,then why to bind gridview with Rohan's records also?

Dholakiya Ankit 26-Aug-13 2:42am

yes i understood i only showing ankit's record but scenario is that if i press f5 then only ankit's record must be shown

Thanks7872 26-Aug-13 2:44am

That is you are making post back. So you can handle it in Page_Load event.

Dholakiya Ankit 26-Aug-13 2:51am

can you give me one pratical demo or link anything that will we easier to understand

Thanks7872 26-Aug-13 2:52am

Regarding what?

Dholakiya Ankit 26-Aug-13 2:58am

i don't get you what u tried to explain me

Dholakiya Ankit 26-Aug-13 2:59am

i have to show by default all records with 25 page size

Thanks7872 26-Aug-13 3:05am

You can apply custom paging as suggested by Tadit in below solution and also refer to this link

http://www.codeproject.com/Articles/106678/Display-Large-Amount-of-Data-in-GridView-with-Sear

Try to understand that. But again with custom paging,you will be presented with 2500 pages(10 records per page),that is 2500 links at bottom of gridview. :( .

There is not any straight forward example of what i explained to you but e.g. you can have dropdown list basis on the criteria as i suggested you using employee's example.

Dholakiya Ankit 26-Aug-13 3:11am

yes i am doing using dropdowns like
25
50
150
200
and page nos at bottom and top
i have put scenarios see my updated question

Thanks7872 26-Aug-13 3:15am

Can you provide me with the details of what you are actually working with? I mean,Which records will be there in grid view? How(From where) you are getting that results? It will be easier for some one if you provide with the actual scenario.

Dholakiya Ankit 26-Aug-13 3:20am

see updated

Thanks7872 26-Aug-13 3:27am

If we consider sale price,then you can provide a way for user to select range. e.g. if i select sale price between 500-2500,then records will be less. Similarly you can provide with the category of the product as well.e.g. No need to display clothes where i am aimed to refer to laptops.This is some thing that i call filtering.

Dholakiya Ankit 26-Aug-13 3:31am

ok trying it may this help me but i think filter is not only issue

Thanks7872 26-Aug-13 3:32am

In short,your target should be to reduce no of records loaded in the gridview,as much as you can.

kishore sharma 26-Aug-13 3:14am

if you need for specific page,use viewstate ,instead gridview.
its just changes not solution for ur need

Dholakiya Ankit 26-Aug-13 3:15am

viewstate instead gridview what u are talking about?

kishore sharma 26-Aug-13 3:19am

ufff sorry instead session
(*gridview)

Dholakiya Ankit 26-Aug-13 3:20am

viewstate shows timeout

Dholakiya Ankit 26-Aug-13 3:20am

and also outof memory

Dholakiya Ankit 26-Aug-13 3:20am

see my updated question

kishore sharma 26-Aug-13 3:50am

Hey can we go with load scroll,i would suggest as per technical limitations
we can not go with showing 25000 records,so display 500 records and when he scrolls down bring other records using http request using webmethod quite complex better use jquery datatable.
if you wanna check this means i will provide link for this.

Dholakiya Ankit 26-Aug-13 4:35am

ok thanks

Dholakiya Ankit 26-Aug-13 23:30pm

Thanks to all i have solved my solution my self there was two session running also datas where binding using very old method but certainly you guidance make my solution better and fast to solve thank u all..............::SMILE::

crazie.coder 27-Aug-13 1:39am

you can use cache rather than session...generate unique cache key for per user..i already implemented it when i was working with time & attendance management system where has more than Lakhes records...

Dholakiya Ankit 27-Aug-13 3:21am

can you give me some link juhi that will be grateful to me

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)

kishore sharma · Answer 1 · 2013-08-25T23:43:00

Solution 3

Check out these links
I know this not the solution for your scenario but why not you change the way you are doing ,try this way.
scroll_y_infinite.html[^]

server_side.html[^]

Posted 25-Aug-13 23:43pm

kishore sharma

Comments

Dholakiya Ankit 26-Aug-13 6:45am

gud 1

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2013-08-25T20:34:00

Solution 1

Go for custom Paging, which will make it faster.

1. Asp.net gridview custom paging example like Numeric, first, previous, next and last[^]
2. CUSTOM PAGING IN ASP.NET GRIDVIEW USING SQL SERVER STORED PROCEDURE[^]
3. How to implement Custom Paging in ASP.Net GridView control[^]

Posted 25-Aug-13 20:34pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Thanks7872 26-Aug-13 2:47am

I am not voting for this,but do you think custom paging is relevant with what OP is asking for? He is aimed to make gridview faster but have 25000 records,then there won't be any performance improvement if he applies this.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 26-Aug-13 3:04am

Thanks a lot Rohan Leuva... :)

Yes, it will improve the performance. That is because the specified number of records per page will be retrieved from the database. It will not retrieve all the records at once. Suppose he wants show 10 per each page, so, 10 number of records will fetched at once and not all the 25000 records. When he will click on 2nd page, then only next 10 records will be fetched.

Thanks7872 26-Aug-13 3:06am

That is 2500 page numbers at the bottom of the gridview,if i am not wrong?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 26-Aug-13 3:17am

Yes, but that will not create a problem, as all the records are not getting fetched at once.

Thanks7872 26-Aug-13 3:22am

My purpose was to provide him with the solution which should be improved as well as logical in order to reduce the data being fetched at the first place. If we consider that this solution will improve the performance,but on the other side no body will go through 2500 pages at once. User will be going to filter data some how. Then why not to present it filtered?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 26-Aug-13 3:34am

Yes, you are right in this regard. Please go on and guide him to reduce the page size. :) :)
I just tried to give OP idea about custom paging concept.

Thanks,
Tadit

Thanks7872 26-Aug-13 3:35am

That would be some what helpful. My +4..:) Lets see how OP rolls... :laugh:..!

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 26-Aug-13 4:13am

:) Thanks...

Mukesh Ghosh · Answer 3 · 2013-08-25T20:35:00

You can try paging in your select Query result from Data Base & not in your aspx page.
Put a combo in your search page which will contain 50,100,150,200 so on & combo value should be 50 default.
now, use paging concept in Data Base.

Check for this link as well
SQL Server 2005 Paging Results[^]

handling large dataset in gridview?

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us