Re: Large number of users on Informix 5/HP

In article <3368CD1B.348E@trifox.com>, Paul Dembry <pade@trifox.com> writes > >Synectics Inc. wrote: >> >> We have an application utilizing ESQL/C and connecting to an Online 5 db. It >> is running on a HP 9000 K400, with 2 processors and 256 MB of memory. I don't >> know how much harddisk is available. The application has a small number (5) >> of base processes that always connect to the database, and a configurable >> number of user-interface processes that also connect to the database. >> >> The client using this application has been running with around 50 >> user-interface processes and therefore a total of 55 connections to the >> database. However, they are going to have the need to increase the >> number of user-interface connections to the database to 400 (they have a site >> license, so we're ignoring legal issues). >> >> Most of these users are connecting to the HP machine across a 10Mb Ethernet >> via telnet. These are curses based interfaces, so we're not talking about >> a bunch of X-window traffic. >> >> Can anyone comment on the viability of doing this? Does anyone have a >> similarly sized system, and how does the db do from a performance standpoint? >> Is this number of connections to the db even a reasonable thing to try, given >> the host computer, etc.? >> >> Any comments are most welcome. Thank you in advance for feedback. >> >> Mark >> ---------- >> Mark Bordner >> mark@synxcti.com > >Our VORTEXc precompiler along with our VORTEXaccelerator would make this >configuration work very well. Please see http://www.trifox.com for >details. >Briefly the VORTEXaccelerator caches cursors across a large number of >users >and connects users to a pool of DBMS slave processes on an as-needed >basis, >similar to a multiplexer. By doing this, you have far fewer actual DBMS >connections than clients. Depending upon your application SQL mix, you >can >often achieve a 10-1 reduction. In your example, the 400 "connections" >would >become 40 actual Informix connections, less than you are running now. > >The VORTEX family of products has been in operation since 1990 and is >used >in many 24x7 operations, such as consumer goods distribution and 911 >record >management systems. You mean a TP monitor - sounds like a good idea... -- David Williams