Cache with SQL dependency?

Question

I know that NCache provides SQL dependency for Microsoft SQL Server and Oracle (10G R4 onwards). I am interested to know what other caching solutions are available, that comes with dependency on Oracle?

Does Velocity, memcached, etc. support SQL dependency to receive notifications/update the cache automatically, when something changes in the database?

Answer 1

If you are using .NET I would recommend taking a look at the System.Web.Caching namespace, more especifically the class CacheDependency. I know it has not, at the moment, dependency on Oracle, thou.

Answer 2

There are some implementations of memcache and NVelocity that support SqlDependency but the ones I know are all paid solutions. Also you need to keep in mind that generating SqlDependency will fill your database with procedures and tables only used for that purpose.... I'm starting to use http://www.alachisoft.com/ for memory caching. The free version has file dependency and that's really cool! As for performance, my company build from scratch the implementation that I'm using now.

Hope this help. :)