Guys,
Quick clarification:
If we have two tables A and B with relationship keys 'XYZ' in both (B
references A) then which is faster:
1) session.query(A).select_by(*[A.c.XYZ == B.c.XYZ])
or
2) session.query(A, B).join('XYZ')
2 should be faster as 1 may require more row scans ?
Also, the below one is returning multiple records when it should return one
(may be join is not happening correctly - anything missing ?.)
--
Cheers,
- A
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
