Hi, I'm getting some surprisingly poor performance from SQLAlchemy in .get() operations. They're typically taking about 100-200ms, though varying quite a lot. Just doing engine.execute() on the echo()ed SQL takes about 10ms. The query is not small, with a few LEFT OUTER JOINS to eagerly loaded attributes, but it's not massive. As far as I can work out, the query generation is responsible for most of the extra time.
Assuming that it's expected that the query generation is quite slow, is it possible to cache the generated queries? I see that you can do so with select objects, but is there a way to do so with O/RM queries? Thanks, Graham --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
