Member Avatar for jainendra.shah

hi frds,
I want to fetch data from a table who contain approx 10 million data or above. I am able to fetch approx 1 million within 3 min. but this is so slow. and also problem to fetch more then 1 million.

I used to data adapter and dataset to fetch.

I want to just send data in blocks to dataset. Does it is possible? If yes so provide help.

Or give any way to troubleshoot this.
thx in advance

  • 2 Contributors
  • 4 Replies
  • 99 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by camilojvarona
Member Avatar for camilojvarona

Hi,

I have found this link

http://www.codeproject.com/KB/database/sqldodont.aspx

You should find articles about multithreading and Background Worker.

>I want to just send data in blocks to dataset

I think that you may use paging and this way retrieve your rows on demand.

Hope this help,
Regards
Camilo

Member Avatar for jainendra.shah

hello frd,
thanks for giving time on my problem. In that link only give concept what do and what not.
I want to some eg. in code of paging.
bye

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.