Re: Bind message

Hi,

The default is not to re-use statements, you have add
prepareThreshold=n to the url where n is greater than 0. What this
means is that after n times of use the prepared statement will be re-
used..

see http://jdbc.postgresql.org/documentation/head/
connect.html#connection-parameters for more details

Dave
On 25-Sep-06, at 1:27 PM, Do, Leon wrote:

> Hi All,
>
> From my understanding, when I create a prepare statement I can
> execute it multiple times and to increase the efficiency. But
> from what I seen from the logging, Postgres always send the same
> message sequences over the wire.
> parse,
> bind,
> describe,
> execute
> ....
> parse,
> bind,
> describe
> execute
>
> It should execute parse only one time right?
>
> If this is not the right forum then please let me know or direct me
> to the right forum
>
> thanks
>
> Leon Do
>
>