468,290 Members | 2,097 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,290 developers. It's quick & easy.

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

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.

Nov 17 '05 #1
2 4936
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.

Nov 17 '05 #2
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.

Nov 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Tejpal Garhwal | last post: by
10 posts views Thread by Doug Bell | last post: by
4 posts views Thread by Peter | last post: by
9 posts views Thread by Anil Gupte | last post: by
4 posts views Thread by LamSoft | last post: by
5 posts views Thread by =?Utf-8?B?SnVsaWEgQg==?= | last post: by
reply views Thread by NPC403 | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.