Re: UseServerSidePrepare default

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: UseServerSidePrepare default
Дата
Msg-id CADK3HHKCcALxzYXmuKiRcmje7MGZ=ff-RStinkTH2auw8-7bMA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: UseServerSidePrepare default  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Ответы Re: UseServerSidePrepare default  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-odbc
Heikki,

I presume this is similar to JDBC's use of server side prepare. If so do you see a performance problem with servers older than 9.2 since Tom's fix to planning prepared statements is only in 9.2 and above ? 

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Thu, Aug 22, 2013 at 3:06 AM, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
On 19.04.2013 22:14, Heikki Linnakangas wrote:
The docs on ODBC configuration options recommend UseServerSidePrepare=1
for server versions 7.4 and above. That's a good recommendation. Given
that "7.4 and above" covers all supported versions of PostreSQL, and
every reasonable version people might want to use a new driver with, how
about we make UseServerSidePrepare=1 the default, so that people don't
need to set it manually?

I hear no objections, so committed. UseServerSidePrepare=1 is now the default, for the upcoming driver version 9.3.X.

- Heikki


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: UseServerSidePrepare default
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: UseServerSidePrepare default