Storing Datasets in Web Farms

[Guest]

Hi

I have an expensive call to the database that returns a dataset and I need
to store this somewhere so that I do not make repeated calls to the database
for the same parameters. What is the best way to tdo this in a web farn
where the session state is not managed on a single server? Putting it in
ViewState will also have performance implications I think since the dataset
can be pretty big. Can someone suggest a methodology and some reading that I
can do to understand this better?

Thanks in advance for any help.

Kan

 

[Ken Cox [Microsoft MVP]]

Hi Kan,

It sounds like something you would want to cache on each machine and then
set up a cache dependency.

http://msdn.microsoft.com/library/d...systemwebcachingcachedependencyclasstopic.asp

I haven't done this, so I can help you much further on how well it works.

What about dumping the expensive results to a SQL table to avoid constantly
creating the dataset?

Ken