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.