Re: [sqlalchemy] simple query takes to long

2022-06-07 Thread Philip Semanchuk
> On Jun 7, 2022, at 5:46 AM, Trainer Go wrote: > > 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

[sqlalchemy] Re: simple query takes to long

2022-06-07 Thread Trainer Go
this is my connection string and query: connection_string = ('DRIVER={Adaptive Server Anywhere 7.0};Commlinks=tcpip{ip=;Port=port};ENG=dbName;UID=uerID;PWD=PW') connection_url = URL.create( "sybase+pyodbc", query={"odbc_connect": connection_string} ) engine =

[sqlalchemy] simple query takes to long

2022-06-07 Thread Trainer Go
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