Do datasets hold all of the returned data in memory? RRS feed

  • Question

  • Hi experts, :-)


    We are in the process of converting an old legacy (DBF) system to C#/SQL server.


    In the old system we use a lot of arrays. When the system was originally designed, the volumes of data we are now processing were not anticipated and so arrays were very quick.


    One of our developers says that datasets hold all of the data from a query in memory. If for instances, "SELECT * FROM someTable" returns 100K results, he says that they will all be cached. I disagree.


    Could someone give me a pointer to the answer/further reading please?


    Many thanks.



    Tuesday, March 18, 2008 10:18 AM


  • DataSets and DataTables keep data in a memory and have no direct communication with the database. They are designed to work as disconnected objects.


    Wednesday, March 19, 2008 9:59 AM

All replies