From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Bind message |
Date: | 2006-09-25 21:14:24 |
Message-ID: | 451846B0.6070906@logix-tt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guy Rouillier | 2006-09-25 21:28:55 | Re: Bind message |
Previous Message | Mark Lewis | 2006-09-25 19:23:18 | Re: Bind message |