Question
I worked on a PHP project earlier where prepared statements made the SELECT queries 20% faster.
I'm wondering if it works on Python? I can't seem to find anything that specifically says it does or does NOT.
Answer
Direct answer, no it doesn't.
joshperry's answer is a good explanation of what it does instead.
From [eugene y answer to a similar question](https://stackoverflow.com/questions/2424531/does-the-mysqldb-module- support-prepared-statements/2425500#2425500),
Check the MySQLdb [Package Comments](http://pypi.python.org/pypi/MySQL- python/):
"Parameterization" is done in MySQLdb by escaping strings and then blindly interpolating them into the query, instead of using the MYSQL_STMT API. As a result unicode strings have to go through two intermediate representations (encoded string, escaped encoded string) before they're received by the database.
So the answer is: No, it doesn't.