.net - ADO vs DataSet and DataTables -
So I did not see the answer to my question:
Is there any difference (display or otherwise) ado Vs dataset? If so, which is more common?
The ADO is the way to actually get the data.
I think you are mixing things.
The dataset is basically a memory representation of the data you have drawn and it is OK to set a small result, but
edit:
its Apart from this, for the big result set, generator list populates through the detrars, as far as the performance goes.
For an example of a dataset, I had to re-write a report that was taking more than 9 hours to run. It was a console application that was generating CSV, the programmer filled 1.4 million records in a dataset, then used for each loop through each line. It took not only 10 hours, but during the walk, it was recalled 4 Gigabits.
After deleting the dataset, the report now runs within 5 minutes and takes approximately 20 MHz of memory.
Just one example.
Comments
Post a Comment