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

Web Application in ASP.NET

Answers (2)