StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POASP.net Caching
text
Body
copied!<p>I have implemented asp.net caching. But I am getting weird results</p> <p>Unlike most caching where you are trying to avoid the amount of hits to the DB. I am trying to avoid any hits to the DB by the user. This is b/c the amount of time the fist page takes to load. It is basically a dashboard with a lot of charts and long running queries</p> <p>I tried several techniques 1) Have the cache time very long and have a schedule process expire and get new cache. 2) and on RemoveCallback</p> <p>In the second option I have all the cache go through a static class I created. The purpose is as it expires to refresh the data. Here is what I am calling.</p> <pre><code>Cache.Insert(dbCacheString, dtNetwork, null, DateTime.Now.AddHours(2), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, new CacheItemRemovedCallback(CacheManager.CacheRemovedCallback)); public static class CacheManager { private static Hashtable times = new Hashtable(); private static bool isRefreshingCache = false; public static void CacheRemovedCallback(String key, object value, CacheItemRemovedReason removedReason) { RefreshCache(key); } public static void StartCache() { string lcUrl = "http://localhost/ratingspage/"; // *** Establish the request try { WebClient client = new WebClient(); client.Credentials = new NetworkCredential("xxx", "xxx", "xxx"); byte[] myDataBuffer = client.DownloadData(lcUrl); } catch (Exception ex) { ErrHandler.WriteError(ex.Message + "\n" + ex.StackTrace.ToString()); LogUtil.LogDebugMessages(ex.Message + ":" + ex.StackTrace.ToString()); } } public static void RefreshCache(string key) { string controlname = ""; if ( key.ToLower().StartsWith("control:") ) { string[] tmp = key.Split(':'); if (tmp.Length > 1) controlname = tmp[1]; else return; } else return; string lcUrl = "http://localhost/ratingspage/Admin/" + " "LoadControl.aspx?CachingSpider=true&Control=" + controlname; string lcHtml = isRefreshingCache.ToString(); // *** Establish the request if (!isRefreshingCache) { isRefreshingCache = true; lcHtml = isRefreshingCache.ToString(); try { WebClient client = new WebClient(); client.Credentials = new NetworkCredential("xxx", "xxx", "xxx"); byte[] myDataBuffer = client.DownloadData(lcUrl); lcHtml = Encoding.ASCII.GetString(myDataBuffer); } catch (Exception ex) { lcHtml = ex.Message; isRefreshingCache = false; ErrHandler.WriteError(ex.Message + "\n" + ex.StackTrace.ToString()); LogUtil.LogDebugMessages(ex.Message + ":" + ex.StackTrace.ToString()); } isRefreshingCache = false; } MailMessage mail = new MailMessage( new MailAddress("jgiblin@univision.net"), new MailAddress("jgiblin@univision.net")); mail.Subject = "Cache Expire: " + key; mail.Body = string.Format("The Key {0} has expired at {1}", key, DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString()) + "\nRefreshing Cache: " + lcHtml; SmtpClient smtp = new SmtpClient("mercury.utg.uvn.net"); mail.IsBodyHtml = false; try { smtp.Send(mail); } catch (Exception ex) { ErrHandler.WriteError(ex.Message + "\n" + ex.StackTrace.ToString()); LogUtil.LogDebugMessages(ex.Message + ":" + ex.StackTrace.ToString()); } } } </code></pre> <p>for some reason, when I go to the page. Someone times the data is cached and sometimes it is not. Is there something wrong here</p> <p>I tried app fabric but since the server does not have iis 7 I am not able to use that</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload