On Apr 12, 2007, at 11:38 PM, Kaali wrote:
I actually tried to use query.instances, but it behaved quite oddly. I
didn't debug or even echo the SQL calls yet, but it made accessing
those instances very slow. The actual instances call was quick, but
when accessing the objects from the
Thanks for the answers.
I implemented message loading with find_members() kind of method, as
shown in the documentation link you gave, and it got twice as fast.
But it's still nowhere near the speed without the ORM. Makes me a bit
sad, as i really liked the ORM system. Maybe if i remove any
On Apr 12, 2007, at 3:30 AM, Kaali wrote:
Thanks for the answers.
I implemented message loading with find_members() kind of method, as
shown in the documentation link you gave, and it got twice as fast.
But it's still nowhere near the speed without the ORM.
i get the impression youre
while on the same subject, how do i copy one object's relatives to
another object without loading them all?
user1.addresses = user2.addreses does not work, it makes them share
the same InstrList
user1.addresses = user2.addreses[:] does work, but fires a full query
(maybe with
sorry, ignore this, started a new thread
--~--~-~--~~~---~--~~
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
I actually tried to use query.instances, but it behaved quite oddly. I
didn't debug or even echo the SQL calls yet, but it made accessing
those instances very slow. The actual instances call was quick, but
when accessing the objects from the resulting list it slowed down to
crawl.
I will
After getting the results, i will filter them with Python filters,
as i don't know how to filter many-to-many queries directly.
Should i somehow make custom queries that handles many-to-many
relationships etc. or is there something else i'm missing that
makes the system slow? I have ran the
sqlalchemy relationships are currently only fully loading - meaning
you cant directly filter on an instances collection attribute.
however you can construct your own query based on the relationship
and use that, and theres plenty of tools to make that easy.
such as, if you set up a