As I understand, dataset is in-memory cache of data. Now consider a webserver were thousands of users are accessing. There is a chance that thousands of dataset are created in this server. If this is the case, is it not going to affect the server performance?

Hi,

The question which you have asked is really a point of consideration.

In my view, the consideration should be at the web application level not at the web server level. It is true that serving a 1000 or more sessions at a time with individual datasets is memory intensive. But all depends on the Tier Architechture of your application. If you keep per user datasets then the system will be memory intensive, however if you share your objects among multiple users in a single time and maintain concurrency then it is great.

All depends on your business logic, performance requirements and more ...

cheers

Anubhav

Anubhav Kumar

It is my understanding that once the page is cached all users access the cached page.

Take a look at this:
http://aspnet.4guysfromrolla.com/articles/022802-1.aspx

In multi tier architecture there should be no problem of this kind.

becoz there is less and less data to be transfered from one system (database) to another(client or web server)

Atul Kumar Sharma