Re: Does rewriteBatchedStatements rewrite into prepared statements or regular ones?

[Mark Matthews]

Hi Juan,

The rewritten batch is an entirely new statement. If the original was a prepared statement, then a new statement is prepared for each chunk of the batch (but these are not parsed each time, the pre-parsed contents of the original prepared statement is used). It effectively uses placeholders, the data is not "inlined".

If the prepared statement itself is cached, it is these pre-parsed contents that are actually cached (The prepared sql is the key in the cache, the parsed form is the value).

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html