Re: Bind message

[Dave Cramer <pg(at)fastcrypt(dot)com>]

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