Re: Degradation of performance when upgrade psqlodbc to 09.03.0400

Поиск
Список
Период
Сортировка
От Dang Minh Huong
Тема Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
Дата
Msg-id 1EDD2A39-78FA-4C80-AC35-9C9FF658C94F@gmail.com
обсуждение исходный текст
Ответ на Re: Degradation of performance when upgrade psqlodbc to 09.03.0400  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Ответы Re: Degradation of performance when upgrade psqlodbc to 09.03.0400
Список pgsql-odbc
Дерево обсуждения
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@dream.email.ne.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


В списке pgsql-odbc по дате отправления: