Delete HttpRuntime.Cache items from an other application

Question

I have an admin application in which I manipulate my objects in the db, and a public asp.net mvc application which is mostly for viewing these objects.

I have implemented a simple caching for a few objects, which uses HttpRuntime.Cache.

I want to invalidate parts of the cache of the public application from the admin application.

The simplest solution was to make a ClearCache() action which clears every record in the cache when called.

But wouldn't it be better to utilize a caching which uses cache dependencies? I don't know which would be the best to use and how. I was thinking about an sql dependency, but since I'm doing the caching to skip sql queries I'm not sure that this would be fast.

Is checking sql cache dependencies slow? I wish to use the cached objects in a LOT of cases, checking for the sql dependency each time does not sound good.

Are the two separate ASP.NET applications? – Darin Dimitrov Jul 04 '11 at 16:44 — Darin Dimitrov, Jul 04 '11 at 16:44
one is a silverlight app, the other one is an asp.net app. – vinczemarton Jul 04 '11 at 20:34 — vinczemarton, Jul 04 '11 at 20:34

score 1 · Answer 1 · answered Feb 17 '12 at 13:16

You can use CacheDependency for it.

If there are two separate applications. You can use file dependency option. (there is also cache key dependency option)

When you touch a specific file (may be just an empty file) from an application. The other application cache items which are depended upon the same file will be automatically expired.

You can use different files to expire different category of cache items.

Michael Freidgeim · Answer 2 · 2011-12-18T10:54:59.867

0

I recommend to have SQL dependency cache per each table or select query for records that suppose to be treated together. You may consider to create separate cache entries for some partitions (e.g. if you have country specific data, keep each country data in a separate cache entry with appropriate SQL dependency).

edited Dec 18 '11 at 10:54

answered Dec 18 '11 at 09:38

Michael Freidgeim

26,542
16
152
170

Actually I solved it by making a ICacheProvider with two implementations on the delete method: Deleting the HttpRuntime cache if the cache is local, and Calling a remote controller action to delete the cache element on the remote application. There could also be an sql dependency implementation but im still not sure if it's a good idea performance-wise. – vinczemarton Dec 20 '11 at 08:59

Delete HttpRuntime.Cache items from an other application

2 Answers2