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