Fetching million data in dataset for datagrid slow down my system.

  • Thread starter Thread starter yatharth
  • Start date Start date
Y

yatharth

Hi Mike


I have Datagrid and i am fetching data around about 1 million into it ,
i think which is not good deal this makes my system slow.Please tell
the way so that i can fetch data in my dataset or else so that i dont
have to fetch such a large data again and again.


My datagrid alows paging.
 
There's NO way you want to fetch 1 million records into a grid. No user can
possible see that much data at once. Also, if you fill a datatable that
already has data, then the new rows will be added. So you can use WHere
whatever between 1 AND 10, then Where whatever between 11 and 20 etc to
simulate paging. 1million rows is a ton of data to be working with and
unless this is batch processing that doesn't have humans using it, there's
probably little reason to ever work with that much data
 
Back
Top