Re: [sqlalchemy] MySQL's STRAIGHT_JOIN in SQLAlchemy?

2012-06-29 Thread Martín Soto
Hello Michael: Sorry for not answering before, but I got sidetracked by other tasks. Your answer is very helpful, thanks a lot! I'm using the ORM, so I'll rather use the ORMStraightJoin solution. By looking into the code (that's easier now that I know what to look for) the only thing I

[sqlalchemy] MySQL's STRAIGHT_JOIN in SQLAlchemy?

2012-06-25 Thread Martín Soto
Hi everyone! I'm currently working on a query that makes the (rather bad) MySQL optimizer choke. After running EXPLAIN, I noticed that MySQL was taking a pretty long time to optimize it (about 130 seconds) and was then producing a rather unintuitive join order. I tried replacing the JOIN