March 26, 2004 at 2:00 am
The new DataAdapters and DataSets in ADO.NET are a wonderful idea and are going to change the way in which SQL Server is used but....
If you are dealing with a disconnected recordset, what happens if the recordset you request is larger than your client machine can cope with?
Does it get the first 'n' records then do something clever when you ask to look at the next 'n'?
It strikes me that if you are developing .NET web applications your web server is going to need massive amounts of RAM.
March 29, 2004 at 8:00 am
This was removed by the editor as SPAM
March 29, 2004 at 7:14 pm
A disconnected recordset generally drops all the data to the client. Thus you will see out of memory errors and the system will bog down for a period until it is able to recover. There are many ways to do things just depends on what you need but no .NET apps need no more RAM than regular apps if designed with need in mind for optimization of the application.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply