M
Mike
Assume i have a db connection and a datareader for that connection. Now I
perform a query that retrieves 100MB of data. I know that the data reader
gets 1 row at a time. However, there is a result set out there that is
100MB is size.
If I close the dataReader but keep the DB connection open, will the 100MB be
freed up after closing the DataReader?
Can I continue reusing the same DB connection and creating and destroying
datareaders assigned to that connect and trust that the memory after the
datareader close will be freed?
Thanks
perform a query that retrieves 100MB of data. I know that the data reader
gets 1 row at a time. However, there is a result set out there that is
100MB is size.
If I close the dataReader but keep the DB connection open, will the 100MB be
freed up after closing the DataReader?
Can I continue reusing the same DB connection and creating and destroying
datareaders assigned to that connect and trust that the memory after the
datareader close will be freed?
Thanks