On Apr 8, 2008, at 7:03 PM, Jonathan Ellis wrote:
> > On 4/8/08, Tim Lesher <[EMAIL PROTECTED]> wrote: >> Yep--that's what I'm doing now. It has the effect of creating >> another >> nested subselect, but I'm not too concerned about that as both are >> relatively cheap EXISTS queries. > > I wouldn't be surprised if PG's optimizer can inline it anyway. Apparently MySQL's cannot. Ben Bangert has terrible results using has() and any(), and gets lightning fast performance after converting them to INNER JOINS. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
