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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update one table from another with DataAdapter 2
How to read a table record by record and process and update another table 1
Large DataSet problem : Please help 1
Dataset with large data...PLEASE HELP 2
Append query - current record only (follow on from Ken Stafford su 2
Important Concurrency questions 1
An array of datasets/tables ? 4
Import and Append of txt files 1

Back
Top