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

[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.

[W.G. Ryan MVP]

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
<ya******@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

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.

[yatharth]

i am using a stored procedure which fetches the data after searching
about millions of data, so even if i use datareader for fetching the
data in datagrid i have to run that stored procedure ,so suggest me
what should i do to increase the speed so that it will remove my
timeout problem.