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

[sqlalchemy] Performance Mystery

2012-07-24 Thread Warwick Prince
Hi All This is addressed to anyone who may be able to shed some light on this strange behaviour; I'm running MySQL on Windows 2003 Server (Sorry) and have a table that has ~2M rows of sales data in it. Knowing the type of BI queries I would want to be doing, I have added indexes where I

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,