Hello guys, Im executing 2 queries in my python program with sqlalchemy using the pyodbc driver. The database is a Adaptive SQL Anywhere Version 7 32 Bit.
When im executing the queries in a DB UI it takes 5-6 seconds for both together and when im using the same queries in my python programm it takes 5-6 minutes instead of 6 seconds. What im doing wrong? Im new at this. would the connection string or query help? And i only selecting some datas from the db and converting it into two dataframes so i dont inserting, updating or deleting datas. I hope somebody can help me. Best regards Manuel -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/b306121e-913c-4ca5-bc2d-6308d76d1b76n%40googlegroups.com.
