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

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

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