> 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
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 =
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