Re: Adding additional Listener ports

gary child wrote: > > It has been suggested to me that adding additional Listener ports to /etc/services > and corresponding aliases to sqlhosts may provide a performance gain by spreading > user connectivity between the multiple listener ports. We run 7.31.UC5 on > HPUX11 and all connections via tcp. > We do not use shared memory connections because we are utilising HP Shmem_magic > to address additional shared memory. Hang on, are you saying you are using TCP for local connections? Why don't you use stream pipes? Adding multiple listeners is only really useful if you have multiple network cards. I don't think you are going to see much gain with local connections unless you have 1000's of users. > I don't recall ever seeing anyone suggest > multiple listener ports as a tuning option so I'd be interested to > hear your thoughts. It is certainly a concept covered in the Sys Adm training course. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+