Re: [SQLObject] memcache

[Oleg B. <ph...@ph...>]

On Mon, Feb 01, 2010 at 01:40:51PM -0500, Stef Telford wrote:
>      *) subclass the SQLObject into another class (which I called 
> CompassObject, since our reservation system is called Compass ;) and 
> overloaded _SO_setValue to do a delete inside memcache on change and 

   To delete the instance from the cache to make the cache coherent?

> overloaded 'get' such that it looks up memcache. I have to del/create 

   I am going to do it in steps. The first step - to make SQLObject
instances pickleable. MemcachedCache would be the next. But I am going to
develop a separate cache class, not hack into .get machinery.

> _SO_writeLock, sqlmeta and _connection on each object when it's returned.

   _connection? Do you mean per-instance connection? In general, the
connection is stored in the SQLObject table class and it doesn't need to be
pickled or restored. But how do you restore per-instance connection?

>      Also, in a totally random thought, you will probably hit the 1mb 
> memcache limit when storing objects.

   What's the limit?

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.