Re: Connections to Informix 7.x

In article <4vpo3q$bv6@nic.global-one.no>, Nils Myklebust <Nils.Myklebus t@ccmail.telemax.no> writes >71242.3522@compuserve.com (John Graas) wrote: > >:Is there any limitation to the number of simultaneous open connections >:that I can have to Informix 7.x or Informix XPS?? I'm looking at an >:application that may require 3,000 connections. > >OnLine 7.2: About 33.000. Max number of open tables per OnLine DS >system is 32.000 though that may set a lower limit for you, but there >should still be no problem with 3,000 connections on this account. >You will also need a recommended average virtual shared memory of 250 >kb per session (given minimum is 35 kb per session) according to the >technical spesifications. There may be other limitations. > >You'll easily find all this and a lot more at http://www.informix.com >under the products heading. >I don't know the numbers for XPS, but wouldn't expect them to be any >lower :-) > > > >Nils.Myklebust@ccmail.telemax.no >NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway >My opinions are those of my company > If you are running across a TCP/IP network. i.e. programs do not run on the same machine as the database server then the limit is about 2,000 (at least I've heard about this on Solaris). This is because you cannot open >~2,000 sockets at the same time due to a HARDCODED kernel limit. -- David Williams