On Aug 24, 2007, at 1:26 AM, Arun Kumar PG wrote:
> 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 ?
assuming one is select from a, b and the other is select from a join
b, theyre equivalent.
>
> Also, the below one is returning multiple records when it should
> return one (may be join is not happening correctly - anything
> missing ?.)
>
turn on SQL echoing and see what its doing.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
