Hi, Kris,
Kris Jurka wrote:
> Sometimes it is, sometimes the purpose of using a PreparedStatement is
> to avoid escaping data yourself for a plain Statement execution. There
> are potential performance penalties for using a "reusable" server side
> prepared statement because it plans them with generic parameters, not
> those supplied in your query. For this reason we want to be sure that
> people will actually be reusing these statements before switching to
> this mode. I believe the default prepareThreshold is set to 5 despite
> what the documentation says.
I remember having read something about delaying the actual planning
until the first parameterset arrives.
Am I mislead by my weak memory?
Thanks
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org