Hello. I hope someone can help us.
We have an ASP.NET application that uses caching, which has given us
dramatic performance benefits..
We use file dependency expiry and sql triggers to create a file, so that we
can expire the cache when database updates are made.
It had been working fine until relatively recently when we noticed that
sometimes the cache was not being cleared as expected. The files are still
being created successfully and the name of the file matches the name of the
cache dependency.
It seems that after an amount of time (or maybe an amount of cached items)
the depency link is severed somehow.
If we reset the web app and thus flush everything, it works ok for a short
while and then stops working again.
We have a page that we use to manually clear items from cache, or indeed
clear everything from cache. This basically creates the files behind the
scenes and puts them in the cache dependency folder.
Using this to test with, I can see that it is working normally straight
after a web app reset. If I click the button everything is cleared from
cache. Sometime afterward (1hr-ish?) if I click the button items are not
cleared from cache.

Has anyone noticed anything like this before? All suggestions greatly
appreciated.

Cheers
Ian