Re: Degradation of performance when upgrade psqlodbc to 09.03.0400

From: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
To: Dang Minh Huong <kakalot49(at)gmail(dot)com>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
Date: 2016-02-16 14:07:01
Message-ID: 56C32D05.3010500@dream.email.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Dang,

On 2016/02/16 12:40, Dang Minh Huong wrote:
> Hi Inoue-san,
>
> I have tested some commits in revision 09.03.0100 and found that your
> "revise MSDTC support" patch made SQLSetConnectAttr issue.
> Can you simply explain how does your patch cause that issue?

MSDTC support isn't directly related to the issue.

Original mistake is I defined autocommit_public field as a member of
ConnInfo.
While revising CC_xxxx functions, I found it inappropriate to call
SOCK_Constructor() (and CC_conninfo_init())
in CC_Constructor(). and I removed them from CC_Constructor(). However
this leaves inconsistent status
that autocommit_public is off but transact_status(internal autocommit
status) is on..
SQLSetConnectAttr(.., SQL_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF, ..)
before SQLDriverConnect()
does nothing and leaves transact_status on.

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Adrian Klaver 2016-02-16 14:41:53 Re: Issue with Money field using ODBC to Access database
Previous Message Michael Paquier 2016-02-16 04:15:58 Re: [BUGS] BUG #13956: ODBC driver has a memory leak with TIMESTAMP(0)