Re: Bind message
| От | Dave Cramer |
|---|---|
| Тема | Re: Bind message |
| Дата | |
| Msg-id | 5F8A6B12-8F85-4586-9E40-2C27C31C9048@fastcrypt.com обсуждение исходный текст |
| Ответ на | Bind message ("Do, Leon" <leondo@lucent.com>) |
| Ответы |
Re: Bind message
|
| Список | pgsql-jdbc |
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,describeexecuteIt 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 forumthanksLeon Do
В списке pgsql-jdbc по дате отправления: