Last post Feb 28, 2012 04:08 PM by azharrahi
Feb 27, 2012 05:14 PM|azharrahi|LINK
I am thinking to use the Cache in order to make the search fast. I want to know what can be happened if I load the large data into the cache. Like 15,000 rows. I will give the 30 minutes time span to exist data in the cache. But I am not sure about the memory
occupied by such large number of rows.
Feb 27, 2012 05:45 PM|Shellymn|LINK
15,000 rows doesnt make any difference.
Feb 28, 2012 08:10 AM|azharrahi|LINK
Thanks for your reply. Well can you also tell me how much data is acceptable in the cache. Because I am afraid if this exceeds above 15,000 also, upto 40,000. Although this is a rare chance, normally it will hold upto 15,000.
Feb 28, 2012 08:19 AM|Dave Sussman|LINK
The answer is "it depends". the more data you store in cache, the larger the working set of the server process is, so it depends on how much memory the server has, and whether any restrictions have been placed on the working set size.
In reality you just have to test this sort of thing to find out the sweet spot. All caching is a trade-off.
Feb 28, 2012 10:16 AM|azharrahi|LINK
well it is true that it depends. However The current memory available is 16 GB. I hope it will be very feasible to load such large data in cache, which will be destroyed after 30 minutes.
By the way thanks for help.
Feb 28, 2012 02:27 PM|roopeshreddy|LINK
If the server runs out of memory, then the cache items will be automatically removed or also you can define some criteria!
You can use cache!
Hope it helps u...
Feb 28, 2012 04:08 PM|azharrahi|LINK
Thanks. Now I am mentally satified to use it. Thanks again