I am working on a way for my app to cache my sqlalchemy objects externally, specifically in memcached. I'm in the thinking and proof of concept stage and I thought I'd ask the list for some wisdom.
Right now I move objects back into the session from the cache using the session._attach function. Is this unwise? merge doesn't work because it hits the database thus defeating the purpose of the cache.
Next, how should I handle relations? I was considering implementing my own list objects that would be cached seperately from the base objects. They would just be a list of ids, and when you ask for a particular one, the list would go check the cache and fallback to the db and return the resulting object.
Hopefully that opens discussion up a bit.
Thanks,
Michael
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
