Re: [sqlalchemy] Slow execution of SQLAlchemy statements vs. plain text

On Mon, May 27, 2019, at 12:05 PM, Sebastian Meinhardt wrote: > Hello, > > given an SQLAlchemy engine `con` (cx_oracle dialect) and a moderately complex > SQLAlchemy selectable object `sql`, the following code will consistently take > ~15 seconds: > > con.execute(sql).fetchall() > > Whereas

[sqlalchemy] Slow execution of SQLAlchemy statements vs. plain text

Hello, given an SQLAlchemy engine `con` (cx_oracle dialect) and a moderately complex SQLAlchemy selectable object `sql`, the following code will consistently take ~15 seconds: con.execute(sql).fetchall() Whereas with the exact same engine and query the following code will only take a