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-11 12:29:31 |
Message-ID: | 56BC7EAB.80102@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Dang,
Doesn't your odbc.ini or connection string contain SOCKET option?
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 <mailto: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
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Pogorelov | 2016-02-11 12:45:22 | Fwd: PSQL iODBC driver on mac os x 10.10.3 (Yosemite) |
Previous Message | Dang Minh Huong | 2016-02-10 23:44:31 | Re: Degradation of performance when upgrade psqlodbc to 09.03.0400 |