Antony Paul wrote:
> In 7.3.3 is there any use in using PreparedStatement since the columns
> may change for each query.
It depends on your application; are there non-column-name parameters? If
so, using PreparedStatement still gives you the benefit that you do not
have to escape those parameters by hand.
Under 7.3.x there's no real performance benefit to reusing
PreparedStatements, as the v3 protocol (supporting server-side query
parameterization and reuse) was only introduced in 7.4. Under 7.4 or
8.0, there is some scope for improved performance if you reuse
PreparedStatements. As your query strings are changing, you may want to
have a cache to preserve a PreparedStatement for frequently used queries.
You really should upgrade if you're still using 7.3.3, at least to the
latest 7.3.x.
-O
