Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Could query execution performance degrade when connecting to the db server through the connection manager?

  • 1.  Could query execution performance degrade when connecting to the db server through the connection manager?

    Posted 10 days ago
    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
    ------------------------------


  • 2.  RE: Could query execution performance degrade when connecting to the db server through the connection manager?

    Posted 10 days ago
    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
    ------------------------------



  • 3.  RE: Could query execution performance degrade when connecting to the db server through the connection manager?

    Posted 8 days ago
    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
    ------------------------------