Re: Savepoints in ODBC driver - Mailing list pgsql-odbc

From Rainer Bauer
Subject Re: Savepoints in ODBC driver
Date
Msg-id 8610280016.20090818214548@munnin.com
Whole thread Raw
In response to Savepoints in ODBC driver  (Rainer Bauer <usenet@munnin.com>)
Responses Re: Savepoints in ODBC driver  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-odbc
Hello,

anybody?

Sunday, August 9, 2009, 10:38:48 PM, I wrote:

RB> Hello,

RB> while checking some performance bottlenecks I realized that the ODBC
RB> driver is creating/deleting a savepoint for *every* command send to
RB> the server.

RB> Grep for SC_start_rbpoint and SC_started_rbpoint to see what I mean.
RB> This does require 3 roundtrips to the server (instead of one) and some
RB> additional processing time for the backend to create/delete the
RB> savepoint every time.

RB> What's the rational behind this? And can this be turned off somewhere?

RB> Rainer


pgsql-odbc by date:

Previous
From: Assaf Lavie
Date:
Subject: Pre-Built Binaries of psqlODBC for 64-bit Windows
Next
From: Richard Broersma
Date:
Subject: Re: Savepoints in ODBC driver