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.
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.
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.
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.
azharrahi
Member
127 Points
238 Posts
large data in cache
Feb 27, 2012 05:14 PM|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.
Shellymn
Contributor
2600 Points
484 Posts
Re: large data in cache
Feb 27, 2012 05:45 PM|LINK
15,000 rows doesnt make any difference.
azharrahi
Member
127 Points
238 Posts
Re: large data in cache
Feb 28, 2012 08:10 AM|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.
Dave Sussman
All-Star
37716 Points
5005 Posts
ASPInsiders
MVP
Re: large data in cache
Feb 28, 2012 08:19 AM|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.
azharrahi
Member
127 Points
238 Posts
Re: large data in cache
Feb 28, 2012 10:16 AM|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.
roopeshreddy
All-Star
20143 Points
3327 Posts
Re: large data in cache
Feb 28, 2012 02:27 PM|LINK
Hi,
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...
Roopesh Reddy C
Roopesh's Space
azharrahi
Member
127 Points
238 Posts
Re: large data in cache
Feb 28, 2012 04:08 PM|LINK
Thanks. Now I am mentally satified to use it. Thanks again