Re: Degradation of performance when upgrade psqlodbc to 09.03.0400

From: Dang Minh Huong <kakalot49(at)gmail(dot)com>
To: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
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 22:25:51
Message-ID: FBDEE456-7353-40C6-9EA5-A10B4295B30F@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Inoue-san,

Many thanks for your support and detail of explaination.
I understood and would like to close this topic.

Thanks and best regards,
bocap

> 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

Browse pgsql-odbc by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2016-02-17 03:01:03 Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!
Previous Message Adrian Klaver 2016-02-16 14:41:53 Re: Issue with Money field using ODBC to Access database