On May 28, 2008, at 4:11 PM, Geoff wrote:
> > Hi! > > I've optimising my database interaction recently and thought that SQLA > might be able to help out with the process. Something like doing an > EXPLAIN on each query and reporting this to the developer. It could > even inspect the indices used and flag up any queries which could need > some TLC. > > No paradigm shift, but would be a handy little time saver :) tricky because EXPLAIN is extremely non-portable. Viewing it in Oracle, for example, usually requires a graphical tool to show one that is at all user-friendly. If you do have an easy-to-use EXPLAIN available, easy enough to log your SQL output and analyze that...what would the Python interface to such a feature look like ? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
