Hello,

I have a bunch of tables which I only read from and store entities
in memcached. Profiler shows me my app spends a significiant amount of time in
__setstate__. So I want SQLAlchemy to:

  1. load those objects from database

  2. do not track their state

  3. still have the ability to use read-only objects in relationships, so I can
  create some non read-only object and relate it to some read-only object

If I understand correctly I need to provide implementation of
sqlalchemy.orm.interfaces.InstrumentationManager which simply does almost
nothing, e.g. manages instance state in instance.__dict__. Is that right? Or I
need to do much more to achieve my goals? And does my goals make any sense or
this is impossible in SQLAlchemy at all?

I've already started to implement InstrumentationManager and have one more
question regarding that. I've installed instrumentation finder but it seems I
can't have different instrumentation manager for class which has relationship
defined to class with standard sqlalchemy.orm.intrumentation.ClassManager --
does it mean I need completely isolate classes with different instrumentation
managers from each other? If yes, that means 3. from the above list is
impossible, so can I somehow workaround this restriction?

Thanks in advance!

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to