Re: Degradation of performance when upgrade psqlodbc to 09.03.0400

Hi Inoue-san,

> Hi Dang,
>
> Doesn't your odbc.ini or connection string contain SOCKET option?
>

odbc.ini does not contain SOCKET option.
I will check the app whether contain it in connection string or not.
And reply you soon.

Thanks and best regards.
bocap

> regards,
> Hiroshi Inoue
>
>> On 2016/02/11 8:44, Dang Minh Huong wrote:
>> Hi Inoue-san,
>>
>> Sorry for my lately response.
>> I am not remember exactly now, but they are like below.
>> # only connection related parameters
>>
>> odbc.ini
>>
>> [PostgreSQL]
>> Driver = PostgreSQLDriver
>> Database = testdb
>> Servername = localhost
>> UserName = postgres
>> Password = postgres
>> Port = 5432
>>
>> odbcinst.ini
>>
>> [PostgreSQLDriver]
>> Description = PostgreSQL Driver
>> Driver = [path to libodbcpsqlw.so file]
>>
>> Thanks and best regards,
>> bocap
>>
>>> On Feb 10, 28 Heisei, at 22:24, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> wrote:
>>>
>>> Hi Dang,
>>>
>>> Thanks.
>>>
>>> How are you setting your ODBC.INI(and ODBCINST.INI)?
>>>
>>> regards,
>>> Hiroshi Inoue
>>>
>>>> On 2016/02/10 12:20, Dang Minh Huong wrote:
>>>> Hi Inoue-san,
>>>>
>>>>
>>>>> Hi Dang,
>>>>>
>>>>>> On 2016/02/09 20:13, Dang Minh Huong wrote:
>>>>>> Hi Inoue-san,
>>>>>>
>>>>>> Thanks for response.
>>>>>> And so sorry for disturbing you at this time.
>>>>>> Please ask if you need aditional information.
>>>>>
>>>>> Are your applications multi-threaded or multi-process?
>>>>> How many connections do your applications use?
>>>>
>>>> It is about 5 connections. And one of them do almost task.
>>>> DB lock wait also not occured as my confirm.
>>>>
>>>> Multi-thread is used but we do not using multi-thread in the same connection.
>>>> # multi-process is not used in the app.
>>>>
>>>> Thanks and best regards,
>>>> bocap
>>>>
>>>>> regards,
>>>>> Hiroshi Inoue