Re: Prepared statements, parameters and logging
От | Dave Cramer |
---|---|
Тема | Re: Prepared statements, parameters and logging |
Дата | |
Msg-id | 9537AA08-53BB-434E-9E62-F326AADED792@fastcrypt.com обсуждение исходный текст |
Ответ на | Re: Prepared statements, parameters and logging (Csaba Nagy <nagy@ecircle-ag.com>) |
Ответы |
Re: Prepared statements, parameters and logging
|
Список | 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
В списке pgsql-jdbc по дате отправления: