Hi,
I've just been debugging a slow running query:
products =
db.Product.query.options(sao.joinedload_all('variations.channels'),
sao.joinedload_all('variations.specifics')).all()
The second joinedload_all should just have been joinedload. It was causing
variations to be included twice in the joinedload, presumably causing a
cross product that made the query very slow.
I can't imagine there's any legitimate need to include a relation twice, so
it would be helpful if SQLAlchemy issued an error for this condition.
Many thanks,
Paul
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
