Web Application in ASP.NET

Question

Hi I want to know that A web application is used to display historical student information from a database server.What is the best cache strategy that will give you the best performance.

Senthilkumar · Answer

Hi Deepak If you want to maintain the historical student information then i hope that you will be having a table in sql server. That you can maintain on Student table should be trigger on delete and you need to add the record into history table.. You can use the data caching in the front end and no need to get from the DB again and again. When there is any changes in the student historical table then only cache has to be recached. For implemtn this ASP.Net 2.0 onwards there is a technique called sqlcachedependency. you can go through this link to know more about this practically. http://weblogs.asp.net/andrewrea/archive/2008/07/13/sqlcachedependency-i-think-it-is-absolutely-brilliant.aspx

brunda k · Answer

http://codebassham.blogspot.in/2011/03/net-40-memorycache-with.html