From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
Cc: | Postgres JDBC <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Prepared statements, parameters and logging |
Date: | 2007-06-25 13:11:39 |
Message-ID: | 9537AA08-53BB-434E-9E62-F326AADED792@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I think the text should be specifying that once you exceed
preparedThreshold executions the driver uses a named prepared
statement, and can re-use it. Otherwise it uses unnamed prepared
statements which need to be prepared for each execution.
Dave
On 25-Jun-07, at 8:42 AM, Csaba Nagy wrote:
> Dave,
>
> If I read [1] correctly, the prepareThreshold parameter should
> actually
> do what I want in protocol version 3... or am I misreading something ?
>
> [1] http://jdbc.postgresql.org/documentation/81/server-prepare.html
>
> Cheers,
> Csaba.
>
> On Mon, 2007-06-25 at 13:24, Dave Cramer wrote:
>> As far as I know you can't have both. In version 3 protocol,
>> everything is a server side prepared statement without parameters.
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-06-25 13:20:04 | Re: a simple example of XA (not working) |
Previous Message | Csaba Nagy | 2007-06-25 12:42:28 | Re: Prepared statements, parameters and logging |