Help on dataset - processing large no. of records

  • Thread starter Thread starter RJN
  • Start date Start date
R

RJN

Hi

We are writing a data processing application wherein we compare data in
2 sets of tables say TableA and TableB and if the data in TableB is
different than TableA, then we do an update/delete/insert operation on
TableB. We're using dataset to do this. These tables have can have
millions of records.Can dataset hold such volume of data? Will there not
be an memory issue? What will be the right approach to this kind
operation?

Regards

rjn
 
RJN,

For what you are doing did they make databases and when it is just
sequential, sequential files.

I doubt if a dataset is the right approach for what you are doing.
Especially deleting from a datatable can be very slow.

Just my idea

Cor
 
Back
Top