Last post May 08, 2012 10:14 AM by XIII
May 08, 2012 10:05 AM|herman_tho|LINK
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.
May 08, 2012 10:14 AM|XIII|LINK
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.