filling a single datatable from multiple threads

  • Thread starter Thread starter Uzi Baruch
  • Start date Start date
U

Uzi Baruch

Hi



I have an environment that has multiple servers and on each server I have a
copy of a specific db with the same table.

I'm looking for an approach to fill a datatable with the info that each
table on each server has.



It should multithreaded task, and an efficient one.



Thanks,
 
hi Uzi
you can use four dataadaptors with four connections.... as long as you
don't define a primary key to the datatable , it add all the new data from
each fill operations " it will not try to overwrite rows that already exist
" ... any way you may want to illustrate more and i will be more that
willing to help as much as i can
 
Hi



Thanks for your reply



I was wandering if a fill operation from multiple adapters on multiple
threads on a single datatable could cause problems because I don’t want it
to become a bottle neck, for the application.



What I did is to run the all the threads simultaneously and then collect
from each thread the result, and use the merge procedure to merge all the
results into a single result set.



I'm looking forward to hear your thoughts about the way I implemented this.



Thanks,

Uzi
 
Back
Top