Help on dataset - processing large no. of records

[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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Cor Ligthert]

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