http://pastebin.ca/1266308
In the link above you will see some output and code. Some questions I have: 1) Why are these queries taking on a magnitude of 10 times slower than they should be? 2) Could it be the implementation I am using? If so what is recommended for using the system as you see it (I can't use ORM based on application requirements) 3) Is the connection being reset between queries? I'd appreciate any insight. I find sqlalchemy's DB connection scheme fits the framework of the rest of the app but if these queries can't be sped up then I'll have to find a different solution. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---