On Aug 15, 2009, at 10:26 PM, gizli wrote:
> > Turning on echo=True spits out all the queries that the application > generates. Currently I am directing this output to a file and then > looking through to derive statistics like what kind of tables are most > frequently accessed. I use this to see where my program can be > optimized. > > Are you aware of any tool built on top of sqlalchemy to do this kind > of analysis and give out a performance report? Not that I know of, maybe someone else has. Setting up a ConnectionProxy to gather the statements from the Connection directly would be a little easier than parsing log output http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/interfaces.html#sqlalchemy.interfaces.ConnectionProxy -- Philip Jenvey --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---