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.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
SenthilkumarPosted Apr 10, 2012, 11:19 PM
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 kPosted Apr 10, 2012, 1:58 PM