Dataset - client or server memory?

  • Thread starter Thread starter timmso
  • Start date Start date
T

timmso

One of my books says a DataSet is holds data in memory on the client.
Another book says it holds data in the server's memory.

Are both of these correct statements?
 
Hi timmso,

In a way yes. When you populate a DataSet from some
databsae, ADO.NET fetches the data and stores it in the
DataSet. The DataSet is stored in the Web Server's memory.
So, if the Web Server is different from the database
server, then the web server is a client for the database
server and if this is what your book meant, then it is
correct.
But the DataSet is never stored on the m/c which is
accessing the web app.

If m/c A is the client browser, m/c B the web server, and
m/c C the database server; then the DataSet will only be
stored on m/c B, never on A or C, unless they happen to be
the same m/cs.

A will only hold the data which is displayed on the page.
That too, not as a DataSet, but as HTML.

HTH
Regards
Harsh Thakur
 
Great. thanks for the explanation.

Harsh Thakur said:
Hi timmso,

In a way yes. When you populate a DataSet from some
databsae, ADO.NET fetches the data and stores it in the
DataSet. The DataSet is stored in the Web Server's memory.
So, if the Web Server is different from the database
server, then the web server is a client for the database
server and if this is what your book meant, then it is
correct.
But the DataSet is never stored on the m/c which is
accessing the web app.

If m/c A is the client browser, m/c B the web server, and
m/c C the database server; then the DataSet will only be
stored on m/c B, never on A or C, unless they happen to be
the same m/cs.

A will only hold the data which is displayed on the page.
That too, not as a DataSet, but as HTML.

HTH
Regards
Harsh Thakur
Click to expand...
 
Back
Top