Informix

Hi All,
Query execution performance is different when connecting to the db server through the connection manager and when connecting directly to the db server.
Is there any reason or defect?

It's hard to see as a network problem. Previously, connection manager 3.50.FC7 and informix server were 11.50.FC7, and only versions were upgraded. There was no problem with the query performance of the client connected through the connection manager.

The connection manager currently being used is 4.10.FC14 and the Informix server is 12.10.FC14X6, and each is on a separate server.

Thanks.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix

Except for proxy type connections there should not be any impact on performance since you actually connect directly to the server. The Connection Manager just tells your application where to find the server and then gets out of the way. Proxy connections continue to go through the CM though and that's where there might be an impact.

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------

Original Message:
Sent: Fri January 08, 2021 02:02 AM
From: SangGyu Jeong
Subject: Could query execution performance degrade when connecting to the db server through the connection manager?

Hi All,
Query execution performance is different when connecting to the db server through the connection manager and when connecting directly to the db server.
Is there any reason or defect?

It's hard to see as a network problem. Previously, connection manager 3.50.FC7 and informix server were 11.50.FC7, and only versions were upgraded. There was no problem with the query performance of the client connected through the connection manager.

The connection manager currently being used is 4.10.FC14 and the Informix server is 12.10.FC14X6, and each is on a separate server.

Thanks.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix

I remember that the proxy type was not specified in the connection manager configuration file, but I will check it again.
Thanks for the advice.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

Original Message:
Sent: Fri January 08, 2021 05:49 AM
From: Art Kagel
Subject: Could query execution performance degrade when connecting to the db server through the connection manager?

Except for proxy type connections there should not be any impact on performance since you actually connect directly to the server. The Connection Manager just tells your application where to find the server and then gets out of the way. Proxy connections continue to go through the CM though and that's where there might be an impact.

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com

Original Message:
Sent: Fri January 08, 2021 02:02 AM
From: SangGyu Jeong
Subject: Could query execution performance degrade when connecting to the db server through the connection manager?

Hi All,
Query execution performance is different when connecting to the db server through the connection manager and when connecting directly to the db server.
Is there any reason or defect?

It's hard to see as a network problem. Previously, connection manager 3.50.FC7 and informix server were 11.50.FC7, and only versions were upgraded. There was no problem with the query performance of the client connected through the connection manager.

The connection manager currently being used is 4.10.FC14 and the Informix server is 12.10.FC14X6, and each is on a separate server.

Thanks.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

#Informix