Informix

 View Only
  • 1.  Curiosity Question

    Posted Fri June 25, 2021 02:46 AM

    Hello,

     

    Is Informix MaxConnect EOL?

    And if so why was this product discontinued?

     

    I am asking this question in order to think about a strategy for client connectivity to servers. Is it still necessary to keep connections always active on the client side or is the overhead that a "connection" requires considered negligible?

     

    Sincerely

    Benjamin

     

     


    #Informix


  • 2.  RE: Curiosity Question

    IBM Champion
    Posted Fri June 25, 2021 07:51 AM
    Benjamin:

    The connection time for a shared memory, stream pipe, or localhost connection is negligible. However, once you are going over the actual network it's not so fast. At any rate, best practice is to maintain connections for the duration because it reduces the overhead in the server, especially if there will be many many applications connecting and reconnecting constantly.

    Here are timings to connect to my local server on my laptop via shared memory and localhost. I don't have another machine that I can use to connect over the network, but you can use my dbping to test it out yourself. Dbping is included in my utils2_ak package which you can download from my web site at: askdbmgt.com/my-utilities

    $ dbping
    dbping started with 5 second timeout at Fri Jun 25 07:46:13 2021

    EXEC SQL CONNECT TO sysmaster@elendil;
    Connection successful in 0.074135 seconds, at: Fri Jun 25 07:46:13 2021
    Actually connected to: elendil on Elbereth.
           Connection named: sysmaster@elendil.

    $ INFORMIXSERVER=${INFORMIXSERVER}_tcp dbping
    dbping started with 5 second timeout at Fri Jun 25 07:46:19 2021

    EXEC SQL CONNECT TO sysmaster@elendil_tcp;
    Connection successful in 0.080352 seconds, at: Fri Jun 25 07:46:19 2021
    Actually connected to: elendil on Elbereth.
           Connection named: sysmaster@elendil_tcp.



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



  • 3.  RE: Curiosity Question

    Posted Fri June 25, 2021 09:03 AM

    Hello,

     

    Thank you for the answer. I'll do some tests with the dbping.

     

    Sincerely