我在中使用MemoryCache。我注意到,当使用MemoryCache.Set()时,如果集合中的项被覆盖,就会出现内存泄漏。考虑以下情况:
->项key=a确实已从缓存中删除,但它的内存仍在MemoryCache中声明。只有当Table1的数据在数据库中发生变化时,才会释放内存。
复制代码:
public partial class Form1 : Form
{
const string cs = @"Data Source=.\sqlexpress;Initial Catalog=TestDB;";
public Form1()
{
SqlDependency.Start(cs);
InitializeComponent();
}
MemoryCache memCache = new MemoryCache("test1", new NameValueCollection {
{ "pollingInterval", "00:00:03"}});
private void button2_Click(object sender, EventArgs e)
{
var dep1 = GetDep("SELECT ID FROM dbo.Table1");
var dep2 = GetDep("SELECT ID FROM dbo.Table2");
var policy = new CacheItemPolicy();
policy.SlidingExpiration = new TimeSpan(2, 0, 0);
policy.ChangeMonitors.Add(new SqlChangeMonitor(dep1));
memCache.Set("a", GetSB(), policy);
var policy2 = new CacheItemPolicy();
policy2.SlidingExpiration = new TimeSpan(2, 0, 0);
policy2.ChangeMonitors.Add(new SqlChangeMonitor(dep2));
memCache.Set("a", GetSB(), policy2);
}
private object GetSB()
{
StringBuilder sb = new StringBuilder(100000000);
for (var i = 0; i < sb.Capacity; i++)
{
sb.Append("1");
}
return sb.ToString();
}
private static SqlDependency GetDep(string sql)
{
SqlConnection con = new SqlConnection(cs);
var cmd = new SqlCommand(sql, con);
SqlDependency dep = new SqlDependency(cmd);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return dep;
}
private void button3_Click(object sender, EventArgs e)
{
GC.Collect();
GC.WaitForPendingFinalizers();
MessageBox.Show("Total Memory Usage = " + GC.GetTotalMemory(true).ToString());
}
private void button1_Click(object sender, EventArgs e)
{
bool exists = memCache.Get("a") != null;
MessageBox.Show("Value exits -> " + exists);
}
}若要使用该代码,请按Button2进行初始化,然后更改表2在数据库中的数据。使用Button3查看可用内存。
发布于 2018-07-06 18:39:02
很可能过了很长一段时间才会回复。
公共覆盖对象删除(字符串键,字符串regionName = null);
在插入/替换缓存的数据之前,应该删除旧键。
https://stackoverflow.com/questions/9905128
复制相似问题