I'm optimizing a large report application which keeps a specific user's tables as DataSets in Session variables. For better performance, is it better to keep several datasets or to have few datasets with datatables in them? Any advice would be appreciated. -Yubo

I would think have fewer dataset objects, but I would think both are going to affect performance similarly. You may have better performance by putting it into the cache.

Brian

Thanks for the advice. Cache cannot be used in this scenario since every user has his/her unique Session variables. Cache is going to make their getting the same dataset.
-Yubo

what are the performance measures you do so you feel you need to make changes for?

Ahmed Ali
Software Developer

I put data in the cache; however, I always prefix the cache key with their user name, which ensures uniqueness. That is another approach.

Brian