Re: [sqlalchemy] Performance Mystery

2012-07-25 Thread Michael Bayer
does this occur with a raw mysqlconnect script ? if so, how about a MySQLdb version of the same thing ? start looking at the DBAPI. On Jul 25, 2012, at 3:45 AM, Warwick Prince wrote: I have taken the SQL entered into the MySQL Workbench (see below) and run that same SQL directly as a

Re: [sqlalchemy] Performance Mystery

2012-07-24 Thread Michael Bayer
One difference that exists here is the usage of bound parameters, which I'm assuming you're not using when you run the query in the console. What happens if you run a test script with straight mysqlconnector ? Try with and without the bound parameters. On Jul 24, 2012, at 11:50 PM,