Re: Savepoints in ODBC driver

From: Rainer Bauer <usenet(at)munnin(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Savepoints in ODBC driver
Date: 2009-08-18 19:45:48
Message-ID: 8610280016.20090818214548@munnin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Richard Broersma 2009-08-18 21:26:49 Re: Savepoints in ODBC driver
Previous Message Mohd Rizal Md Noor 2009-08-18 14:25:30 Build new table using VB.NET in PostgreSQL