Do I really need to build a custom caching engine?

[thedotnetarchitect]

To keep the background simple here is my problem, I have two web
servers in a web farm I would like to have a centralized caching system
on another server, where I can add and remove items from cache from
that one central server, the other two web server will share the cached
data from this server such as serializable business objects and data
objects. I would like the storage system to be SQL server and the data
that is shared from the cache is not session specific but the cache
data is accessible to all session running on either server. Is this
possible now or do I need to build a custom caching engine based on sql
server that these to web server can access to render data to any and
all users.

[John Lee]

You can point your sessionState to a sql server, then put those objects
inside application object so it will be available to all session. Cache is
not for that purpose.

<th************ ****@gmail.com> wrote in message
news:11******** *************@3 8g2000cwa.googl egroups.com...

To keep the background simple here is my problem, I have two web
servers in a web farm I would like to have a centralized caching system
on another server, where I can add and remove items from cache from
that one central server, the other two web server will share the cached
data from this server such as serializable business objects and data
objects. I would like the storage system to be SQL server and the data
that is shared from the cache is not session specific but the cache
data is accessible to all session running on either server. Is this
possible now or do I need to build a custom caching engine based on sql
server that these to web server can access to render data to any and
all users.

[Peter Bromberg [C# MVP]]

You can do it, but you need a "transport" mechanism that is visible and
usable from any of the machines on the farm. I wrote one using Named Pipes,
any machine can connect to the Cache Service on the "Cache machine" via Pipes
and it uses familiar indexer -type Cache semantics. Doesn't use SQL Server,
but could be made to do so quite easily:

http://www.eggheadcafe.com/articles/20060404.asp

Hope that's useful to you.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"th************ ****@gmail.com" wrote:

To keep the background simple here is my problem, I have two web
servers in a web farm I would like to have a centralized caching system
on another server, where I can add and remove items from cache from
that one central server, the other two web server will share the cached
data from this server such as serializable business objects and data
objects. I would like the storage system to be SQL server and the data
that is shared from the cache is not session specific but the cache
data is accessible to all session running on either server. Is this
possible now or do I need to build a custom caching engine based on sql
server that these to web server can access to render data to any and
all users.