To clarify, when prepareThreshold is set to zero, the driver still uses prepared statements, but it uses only the unnamed variant, which should effectively have no overhead compared to inlining parameters. The separate log messages are due to this change. Safely passing in parameters is an important reason to use prepared statements (perhaps more so than performance), so as to protect against SQL injection. For what it's worth, based on the logs, it looks like you're not doing that; you should seriously consider making that change, especially if data like user names is coming externally. This email has been scanned for viruses by Blackspider's Mail Control System. For more information please visit http://www.blackspider.com
This message has been scanned for malware by SurfControl plc. www.surfcontrol.com