Note however that there's, as I know off at this very moment, no SQL Server Agent running to cleanup once the session has expired for a person so you'll likely need a worker role for that to run everey minute or use Paralellism in your webrole to cleanup
every minute. Otherwise your database will grow and it'll become costly or not updateable anymore if you go over your size limit.
herman_tho
Member
197 Points
128 Posts
Memory Cache
May 08, 2012 09:05 AM|LINK
Hi Guys,
I have Azure apps and i have 4 instances.
basically the cached i'm done in the instances, when i have 4 instances there is 4 caches i want to bring this caches into Database Level.
Do anyone have an example how to stored all the cached in the DB Level.
Regards,
Herman
XIII
All-Star
182690 Points
23458 Posts
ASPInsiders
Moderator
MVP
Re: Memory Cache
May 08, 2012 09:14 AM|LINK
Hi,
you could migrate your local database in which you put the scripts already for Session state and altered your web.config. Then after migration you need to alter your web.config as well (http://www.microsoft.com/en-us/showcase/details.aspx?uuid=ac10774f-c127-4689-8068-7fac9f08ef6e).
Note however that there's, as I know off at this very moment, no SQL Server Agent running to cleanup once the session has expired for a person so you'll likely need a worker role for that to run everey minute or use Paralellism in your webrole to cleanup every minute. Otherwise your database will grow and it'll become costly or not updateable anymore if you go over your size limit.
However there's a Caching service available in Azure for you to use: How to Use the Caching Service.
Grz, Kris.
Interested in Azure, ASP.NET (MVC), jQuery, WCF, EF, MS SQL, ...
Keep the forums clean: report to the moderation team!