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 = create_engine(connection_url)
conn = engine.connect()
res = conn.execute("select ").fetchall()
table_df = pd.DataFrame(res)
its an simple query..
Trainer Go schrieb am Dienstag, 7. Juni 2022 um 11:46:31 UTC+2:
> 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/59010ed7-0ee2-4704-978a-5539b877240bn%40googlegroups.com.
