RE: 4ge-progs slow on big machine

Ann Barnes wrote: >Date: Wed, 24 Jul 91 15:16:23 EDT >From: Root@letterkenn-emh1.army.mil >To: informix-list@RMY.EMORY.EDU >Cc: root@letterkenn-emh1.army.mil >Subject: Unisys Informix SQL slow >X-Informix-List-Id: <list.258> >Status: RO > >We have Informix SQL/4GL on a Unisys 5000/90. It has 25MHz boards, EDT >controller, DMC4 controller, and 44 Mb of memory. Approx 40 simultaneous >users, 24 in Informix of one type or another, other in OFIS, UNIFY, Tactician >spreadsheets and misc. Informix is SQL 2.10.03G and 4GL RT 1.10.03G (std. >for DA Minis sites). > Our users experience extremely slow load times for .4ge files which have >been generated by our application developer. some of these files are 1MB+, >and can take 45 secs to load (user chooses item off 4ge menu and it takes >45 secs to come up with "form" he called for). On another Unisys system, >with same software levels, but Development 4GL, 5000/80 (slower), and only >5-8 users it loads in 15 seconds. Is there anything that could be done >as an end-user administrator (not the application developer) to make this >go faster? Our kernal has been tuned best we know how, cannot have any more >buffers in it. Particularly interested in hearing from DA Minis sites running >AFES (which this is). OK to reply to root@letterkenn-emh1.army.mil >directly if you feel it has little public interest. Thanks. >Ann Barnes, AV 570-9869. > I had a similar problem when I changed the Version at our SIEMENS MX500. There was added a lot (>1000) of virtual terminals and the get_tty - call was very slow. After rearranging /dev/tty there was no more problem. Perhaps this can be the solution of Your problem. Rearranging /dev: # Prozedur zum Umorganisieren des /dev-Dateiverzeichnisses # Modifikation zur besseren Sortierung der tty's zur Beschleunigung des Systems # # Diese Prozedur muss im Single-User-Modus aufgerufen werden, da saemtliche # Dateisysteme abgehaengt werden muessen echo "/etc/devreorg.neu - Neuorganisation des /dev/Verzeichnisses" trap ' ' 2 3 15 if [ ! -z "`who`" ] then echo " Die Ausfuehrung dieses Shell-Scripts ist nur im Single-User-Modus moeglich. Bitte fahren Sie die Anlage in den Single-User-Modus runter und starten Sie das Shell-Script erneut! " exit 1 fi /etc/umount -a mv /dev /dev.sav echo "Wiederherstellen der /dev-Eintraege..." mkdir /dev chmod 755 /dev cd /dev.sav # zuerst die Konsole mv ttyc0 /dev # Standard-Terminals for i in `ls -d tty[0-9]*` do mv $i /dev done # die ersten 32 virtuellen Terminals fuer screens for i in `ls -d ttyp?` do mv $i /dev done for i in `ls -d ttyq?` do mv $i /dev done # die ersten virtuellen Terminals fuer collage for i in `ls -d ttyA?` do mv $i /dev done for i in `ls -d ttyA??` do mv $i /dev done # die ersten virtuellen Terminals fuer LAN for i in `ls -d ttyp00?` do mv $i /dev done for i in `ls -d ttyp01?` do mv $i /dev done # so jetzt die restlichen Terminals in alpha - Reihenfolge for i in `ls -d tty*` do mv $i /dev done # und jetzt die anderen devices for i in `ls -d *` do mv $i /dev done cd / rm -r /dev.sav echo "Fertig." Also the file /etc/ttys must be rearranged. I hope this helps Dieter ******************************************************************************** * Dr. med. dipl.-math Dieter Becker ** Tel.: (0 / +49) 6841 - 16 3046 * * Medizinische Universitaets- und Poliklinik ** Fax.: (0 / +49) 6841 - 16 3369 * * Innere Medizin III *********************************** * D - 6650 Homburg / Saar ** email: * * ~~~~~~~~~~~~~~~~~~~~~~~ ** becker@sbuvax.cs.uni-sb.de * ********************************************************************************