ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  Using SQL Cache Dependency
Subject:   Cache and Timing
Date:   2007-08-29 09:27:03
From:   Skyfish
What happens when the database value changes while a request that uses the cached object is in the middle of processing?


For example:

public void MyMethod()
{
string strValue = (string)Cache.Get("StringValue");


if (strValue == null)
{
' assume that "dependency" is a cache file dependency
Cache.Insert("StringValue", "hello", dependency);
'... cache file dependency triggers because the file was modified ...
'Cache("StringValue") is invalidated
Response.Write((string)Cache.Get("StringValue"));
'unexpected results appear
}
else
{
Response.Write(strValue);
}
}