Cache Expiration Problem in ASP .Net
-
I want to cache sql view having more than 1 lakh records with more than 600 columns. At present i am caching the entire records in a single cache but it occupies nearly 0.5GB memory of my RAM. But the problem am facing is that i could not maintain the cache in the server for a period where i have set a absolute expiration of 10 hours, But the cache doesn't maintaini in the server for the mentioned expiration time. I have seen one article which says the size limitation of a cache must be between 2-3GB. Please suggest me * What are the limitations in caching where in a huge data handling project? *How can i play around with Caches in terms of dependencies both hardware and software? *What are the measurement criteria that needs to be taken care in Cache sizes and expiration policies? *On a given day we update the cache atleast thrice. so i need to recache it for certain interval of time. what are the advisables i need to take care of? Thanks in advance :)
-
I want to cache sql view having more than 1 lakh records with more than 600 columns. At present i am caching the entire records in a single cache but it occupies nearly 0.5GB memory of my RAM. But the problem am facing is that i could not maintain the cache in the server for a period where i have set a absolute expiration of 10 hours, But the cache doesn't maintaini in the server for the mentioned expiration time. I have seen one article which says the size limitation of a cache must be between 2-3GB. Please suggest me * What are the limitations in caching where in a huge data handling project? *How can i play around with Caches in terms of dependencies both hardware and software? *What are the measurement criteria that needs to be taken care in Cache sizes and expiration policies? *On a given day we update the cache atleast thrice. so i need to recache it for certain interval of time. what are the advisables i need to take care of? Thanks in advance :)
-
I want to cache sql view having more than 1 lakh records with more than 600 columns. At present i am caching the entire records in a single cache but it occupies nearly 0.5GB memory of my RAM. But the problem am facing is that i could not maintain the cache in the server for a period where i have set a absolute expiration of 10 hours, But the cache doesn't maintaini in the server for the mentioned expiration time. I have seen one article which says the size limitation of a cache must be between 2-3GB. Please suggest me * What are the limitations in caching where in a huge data handling project? *How can i play around with Caches in terms of dependencies both hardware and software? *What are the measurement criteria that needs to be taken care in Cache sizes and expiration policies? *On a given day we update the cache atleast thrice. so i need to recache it for certain interval of time. what are the advisables i need to take care of? Thanks in advance :)
I think you may want to look at my article: Pfz.Caching - ViewIds instead of ViewStates[^] With it, instead of using Cache you could use Session or ViewState. It will try to use the object that is still in memory but, it that's not possible, it will reload the file (so you will probably don't get out-of-memory exceptions). Also, recently used files are "kept alive", so the information can be kept alive forever if it is used frequently. But, I must say you should really consider changing the way you are working with your data... keeping 500mb of data in memory is too much.