Re: Degradation of performance when upgrade psqlodbc to 09.03.0400

Hi Inoue-san,

> 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.
>

Connection string also not contain SOCKET option (only DSN is set in there).

Thanks and best regards,
bocap

> 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