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.
In response to
pgsql-jdbc by date
|Next:||From: Craig Ringer||Date: 2012-09-17 05:06:39|
|Subject: Re: Bug : FAST_NUMBER_FAILED when getting NaN on BigDecimal|
|Previous:||From: Dave Cramer||Date: 2012-09-13 19:24:36|
|Subject: Re: Change in Log Format and Prepared Statements|