Re: Major performance problems with Informix Online

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.