When you call create_engine:
e = create_engine(url, echo=True) include the "echo=True" part. Then look at the SQL being emitted. That's the important part here. On Wed, Aug 30, 2017 at 5:09 PM, Ken MacKenzie <deviloc...@gmail.com> wrote: > So the big difference between the methods when seen with print(q) > > Textual SQL is building a statement with the values inline > > such as where college=888 and check=1234567 > > The methods using the column object are building with parameters > where college = (?) and check = (?) > > That is all I can see different. > > > On Wednesday, August 30, 2017 at 4:41:38 PM UTC-4, Ken MacKenzie wrote: >> >> I am noticing the 16 execute calls. There should only be 10 with a batch >> size of 1000 and a record size of 9,000 and some change. >> >> Are you just wanting to see the sql via a print(q)? >> >> On Wednesday, August 30, 2017 at 2:01:31 PM UTC-4, Mike Bayer wrote: >>> >>> it looks like you have 16 SQL statements that take a very different >>> amount of time depending on format. Can you please paste the output >>> with echo=True on create_engine() so that the difference in SQL >>> statements can be seen? > > -- > 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 sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
