Re: Degradation of performance when upgrade psqlodbc to 09.03.0400 - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
Date
Msg-id 56C32D05.3010500@dream.email.ne.jp
Whole thread Raw
In response to Re: Degradation of performance when upgrade psqlodbc to 09.03.0400  (Dang Minh Huong <kakalot49@gmail.com>)
Responses Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
List 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

pgsql-odbc by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [BUGS] BUG #13956: ODBC driver has a memory leak with TIMESTAMP(0)
Next
From: Adrian Klaver
Date:
Subject: Re: Issue with Money field using ODBC to Access database