Re: Max-Connect

You might want to take a look at "Guide to Informix MaxConnect " http://www-3.ibm.com/software/data/informix/pubs/library/interim/6678-pdf.html section MaxConnect Benefits in the MaxConnect Overview chapter. You can get performance improvements starting with 200 connections. Helen "Mark D. Stock" <mdstock@MydasSol To: "Link, David A." <DALink@west.com> utions.com> cc: informix-list@iiug.org Sent by: Subject: Re: Max-Connect owner-informix-li st@iiug.org 05/20/2003 04:17 PM Don't post mime. Link, David A. wrote: > When should a person look at using MaxConnect? Our environment is > constant connections to the database, so does MaxConnect gain us > anything? We wouldn’t have so many session resources which will save > on memory. We are currently not having any problems but I want to be > prepared. I have heard that one should look at Maxconnect when you get > around 1000 connections. Is this true? You would look at using MaxConnect if you had 1000's of users and suffered from performance issues, particularly with connection speeds. Also areas like network performance/bandwidth problems. MaxConnect will multiplex connections to the database, so cutting down on actual connections. You need to be careful how you set it up, in terms of where MaxConnect is installed. To my mind it is going to be of more benefit on the app server rather than on the DB server, BYMMV. > Basic info ----- > > OS: AIX 4.3.3 > IDS: 9.30.uc2 > 12 CPU > Single NIC > 6 gig memory Thanks for supplying the info. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+