Re: UseServerSidePrepare default - Mailing list pgsql-odbc

From Dave Cramer
Subject Re: UseServerSidePrepare default
Date
Msg-id CADK3HHKCcALxzYXmuKiRcmje7MGZ=ff-RStinkTH2auw8-7bMA@mail.gmail.com
Whole thread Raw
In response to Re: UseServerSidePrepare default  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: UseServerSidePrepare default  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List 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 by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: UseServerSidePrepare default
Next
From: Heikki Linnakangas
Date:
Subject: Re: UseServerSidePrepare default