SQL 2008 CLR Trigger to update memory cache in ASP.NET application
Posted on 2010-09-21
I have a web page (ASP.NET) requesting constantly data from the server by querying db.
Problem is that there are lots of requests and db is heavily loaded by the queries.
So I was thinking about creating static list (some kind of cache) inside ASP.NET app. containing record from queried table.
All the requests would read directly from that cache.
Now I need a good way to update list after update is done on db. table.
I was thinking about CLR trigger with some remoting to ASP.NET app.
However it's quite complex (not even sure how to do it yet) maybe some of you has a better (easier) solution?
I'm using .NET 4.0, SQL 2008 Web ed.
Thanks a lot for any ideas