All, I am using memcached on windows server 2003 and using Be.IT memcached client.
How can i remove cache object when any direct database change occur, i want to invalidate / remove cache objects from memcached server, for this i am thinking about the CLR stored procedure. What if i write a trigger that activate on Update/Delete evetns and call the CLR stored procedure to remove cache objects? somebody tried this thing before? Thanks
