Subject: | Use new prepared statement API |
DBD::mysql doesn't really prepare statements. All it does it return a dummy sth, after counting placeholders.
MySQL has a real prepared statement API. Using that would probably be much faster, and takes care of placeholder counting and interpolation (which is no longer interpolation).
See http://dev.mysql.com/doc/mysql/en/C_API_Prepared_statement_functions.html