Re: Major performance problems with Informix Online
Philippe Verdy wrote: > > General wrote article +ADw-34336fe3.1263254+AEA-news.demon.co.uk+AD4-: > +AD4-We upgrade from Informix SE to Informix Online about a week ago and > +AD4-since then have been experiencing significant performance problems+ADs- > +AD4-significant enough to make the system virtually unusuable. Queries > +AD4-which previously took 2 or 3 seconds are escalating up to 1-2 minutes. > > +AD4- > +AD4-Our support people have all drawn blanks and we are now even > +AD4-considering wiping the box and resorting back to the old version by > +AD4-restoring from tape (thus losing a weeks worth or work and data). > +AD4- > +AD4-We suspect the problem could be with the configuration of Online and > +AD4-would appreciate any assistance which is available. > +AD4- > +AD4-The configuration of the box is as follows: > +AD4- > +AD4- Siemens Nixdorf RM600 containing > +AD4- 8 RISC Processors > +AD4- 900MB RAM > +AD4- 80GB Disk Space > +AD4- Approximately 60-80 users. > +AD4- It's running a Patient Administration System > +AD4- > +AD4-Below is a copy of the online configurations (there are two on our box > +AD4-and i'm not sure which is being used.) > +AD4- +AFs-snip+AF0- > +AD4-Assistance is urgently required+ADs- please e-mail petew+AEA-grimhosp.demon.co.uk > +AD4-Pete > > Did you do that change in order to change your network architecture ? > If so, do your new clients suffer from network performance using > Informix-Net instead of performing a remote telnet shell on the server ? > > Then you should know that Informix-Net has a cost on the network: if yo > declare large datatypes like VARCHAR(255), Informix-Net transport them as > 256 bytes on the network socket. Such a performance problem does not exist > while using IPC or a telnet-like ASCII based connection protocol over the > network. > > This is also a major issue if you want to access your Informix server using > Informix-Net over a WAN link (such as a PPP connection over RTC or ISDN). In > such a case, you may have to consider some other middleware solutions for > networking. Not to be a nit, but I've done the Inet thang over RAS PPP (NT) with a Delphi application, and was surprised at the speed of the connection. Delphi also does quite well across the pipe in a regular network, as fast or faster than my old friend 4GL. And the app is loaded with char and varchar fields. The connection is made with the Borland ODBC/Inet combination. Sure. on RAS/PPP some of the stuff is slow, but much of the app was surprising fast over a modem. I was impressed, for a GUI app, and ODBC/Inet. The queries come back quite fast, such as look-ups, etc. And for anyone on this thread: I <was> curious to some of the tuning information, were these recommendations purely for a Siemens machine or were these for 7.2x in general? A couple of the recommendations were interesting ( yes experience here ) and I want to know a little more reasoning, if you can elaborate. I'm in learning mode here. :-) Questions about the responses ( Koens and Davids ): 1. The logging information was a bit confusing. 2. NUMCPUVPS looked ok, even low, I've heard use (CPUs - 1) as the rule? 3. NOAGE and affinity can cause problems on some systems, I'd turn them on last. 4. I wouldn't diddle with PHYSBUF OR LOGSBUF sizes. Why would you change these? 5. Using OSTIME, and using the system instead of internal. Does this apply to other machines? 6. RA_PAGES. What's your theory here? :-) 7. OPCOMPIND is ok to use with 7.2x?? I heard this was a showstopper. Again, I'm very curious... Thanks in advance, Tim -- Tim Schaefer \\\\|// tschaefe@mindspring.com 6 6 -------------------------oOOo---( )---o00o---------------------- http://www.inxutil.com - My Ezine http://www.informix.com - Informix Software Inc. http://www.iiug.org - International Informix User Group/FAQ news://comp.databases.informix - Newsgroup for Informix Users ================================================================