Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

Next:From: Guy RouillierDate: 2006-09-25 21:28:55
Subject: Re: Bind message
Previous:From: Mark LewisDate: 2006-09-25 19:23:18
Subject: Re: Bind message

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group