Re: Informix problem or OS problem?
From: "Nick Tran" <nick.tran@xpedior.com> > >We have a SQL that executes in 0.30 seconds. However, when we have two >users executing the same SQL, our time doubles to 0.60 seconds for both to >finish. A third user would add another 0.30 seconds on average. > >Would anybody know how this could happen? Would it be Informix not scaling >properly or the OS not handling DB connections very well? We are using HP >UX by the way. I've got a piece of string in my pocket. How long is it? It's red, by the way. Sheesh, could you be any less specific? How about the SQL, product versions (server & client), onconfig? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
The numbers I gave are just for one SQL. However, the same phenomon happens with any SQL of all complexity--from the most simple to most complex. Our Informix dbase is version 7.x running on HP-UX 11. We are exectuing the query from the unix command line via a telnet session, so the client is not a problem. I'm not sure what you mean by onconfig. I'm not in charge of administration of the dbase, so my knowledge of it is very limited. Is that enough information? > >We have a SQL that executes in 0.30 seconds. However, when we have two > >users executing the same SQL, our time doubles to 0.60 seconds for both to > >finish. A third user would add another 0.30 seconds on average. > > > >Would anybody know how this could happen? Would it be Informix not scaling > >properly or the OS not handling DB connections very well? We are using HP > >UX by the way. > > I've got a piece of string in my pocket. How long is it? It's red, by the > way. > > Sheesh, could you be any less specific? How about the SQL, product versions > (server & client), onconfig? > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > >
In article <6IjM4.556$t25.164748@news.pacbell.net>, Nick Tran <nick.tran@xpedior.com> writes >The numbers I gave are just for one SQL. However, the same phenomon happens >with any SQL of all complexity--from the most simple to most complex. Our >Informix dbase is version 7.x running on HP-UX 11. We are exectuing the >query from the unix command line via a telnet session, so the client is not >a problem. I'm not sure what you mean by onconfig. I'm not in charge of >administration of the dbase, Presumably you are posting here as you have spoken to the person who is and not got satisfaction? > so my knowledge of it is very limited. Is that >enough information? No! If you are not part of the team (maybe a team of 1) administering the box & Informix it will be very hard for you to do anything other than use 'set explain on' to check your SQLs are sensible. If there is a genuine problem someone somewhere will need to work out what it is and then alter the Informix configuration (onconfig is the configuration file for IDS, SE doesn't have one) and / or the machine / Unix configuration to alleviate the problem. <snip> -- Surfer!
Obnoxio The Clown wrote: > > I've got a piece of string in my pocket. How long is it? It's red, by the > way. > I can lend you a measuring tape if you wish. It works with any colour, by the way. ;-) -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web & HTML Report Generator) ESQL/C Compiler For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------