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 :)
Loading
Roei BarPosted Nov 20, 2009, 2:03 AM
caching is a very complex issue though it doesnt look like it,
you have 3 types of caching here is something to read on:
http://www.csharphelp.com/archives4/archive608.html
now about your issue on how to maintain cache i would recommend you to use a distributed cache machanisem like MS Velocity, MemCache and some others,
in this type of caching you will practicly have a caching machine that you can have dependencies per object and per the entire cache in each node hosting it.
the second thing is what you desire, you have an update to perform update 1 node and let the site continue to work with the other nodes, once the update has completed the nodes will do a self update :-) and no performance issue will occour
hope this helps