[Zope-DB] Invalidating ZSQL Method Cache

Ian Bicking ianb at colorstudy.com
Fri Apr 16 11:54:08 EDT 2004


Jesse Pavel wrote:
> If I know that the cached value for an SQL query that a
> ZSQL Method is storing has become stale, is there any way
> that I can invalidate that cache item so that the next
> time the method is run it queries the RDBMS?
> 
> I suppose I could write an external method to poke around
> in the DA.DA instance, but that doesn't seem to be too
> robust a solution.

Check out:

http://www.dieter.handshake.de/pyprojects/zope/CCSQLMethod.html

There are reasons why it's difficult to control the cache.  Maybe 
because it's per-thread?  Anyway, that product allows for cache 
invalidation.

   Ian



More information about the Zope-DB mailing list