小弟的一个项目用了ASP.NET的Cache,可是调试程序的时候发现Cache的命中率好低
这个Cache基本上是仿照PetShop4.0写的,看一下逻辑层的一段代码,感觉命中率好低啊!
public DataTable SelectLsgInfo() { DataTable myTable = (DataTable)HttpRuntime.Cache[LSG_INFO_WHB]; if (myTable == null) { sql = "select lingshigong.id,lsgname,phone,duiname,bianhao from lingshigong, duiinfo where lingshigong.dui_id = duiinfo.id"; myTable = DbLink.ExecuteDataTable(linkstr1, sql, CommandType.Text); AggregateCacheDependency cd = DependencyFacade.GetLsgCache(); HttpRuntime.Cache.Add(LSG_INFO_WHB, myTable, cd, Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(30), CacheItemPriority.Low, null); } return myTable; }