Re: Bind message

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

In response to

Responses

Browse pgsql-jdbc by date

  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