Re: Performance problems with INFORMIX-SE 7.10.UD1

This is exactly why version 6.0x of I4GL was introduced! Using the Relay Module (RM) interposes an extra (largely unwanted) process into the connection, and this makes the performance poor compared with the native 6.0x connection. 4.1x I4GL talking to 6.0x or later OnLine: +-------------+ +--------------+ +-------------------------+ | Application |--->| Relay Module |--->| OnLine DSA Server Thread| +-------------+ +--------------+ +-------------------------+ 6.0x I4GL talking to 6.0x or later OnLine: +-------------+ +-------------------------+ | Application |----------------------->| OnLine DSA Server Thread| +-------------+ +-------------------------+ The new 6.0x connectivity provides better performance and allows many applications to connect to a single server (a single DSA server may run many user (application) threads). Using the RM should only ever be a transition measure, because not only does the RM have to talk to the server using the same protocol as 6.0x I4GL does, but it also has to talk to the application using the pre-6 protocol, which uses two pipes connecting two processes. The RM provides almost transparent access for old applications, but 'almost' excludes the environment variable SQLEXEC and the performance. To upgrade the performance, use 6.0x I4GL! Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >Date: Wed, 6 Dec 1995 21:42:31 -0500 >From: Melvin Perez Cedano <m.mejia@server1.codetel.net.do> >X-Informix-List-Id: <list.8150> > >Recently, I upgraded my INFORMIX-SE database server from 4.10 to 7.10.UD1. >The applications was developed under Fourgen/INFORMIX-4GL RDS 4.10.UD3. > >The database migration was made using DBEXPORT/DBIMPORT utilities. Accesing >the database thru DBACCESS the performance looks similar than previous one, >but when accessing thru the application is poor. I didn't change the tools, >then I didn't compile the programs either. May this affect? > >The situation looks worse when I try to view a table schema thru DBSCHEMA >utility. It takes a lot of time, but really a lot!!!!! that's unbelieveble!! > >I already ran an UPDATE STATISTICS, and the SQLEXEC environment variable is >set to $INFORMIXDIR/lib/sqlrm > >what's going on here? >Anyone has a similar experience? >May I have to run a process in my database for improve performance? > >Any help is welcome!! > > ////// >+------------------------------ooo-O-O-ooo--------------------------------+ >| U | >| Melvin Perez Cedano Santo Domingo, Dom. Rep.| >| Vice-President m.mejia@codetel.net.do | >| Systems Development Phone (809) 686-5574 | >| CAM Informatica, S. A. Fax (809) 686-5467 | >+-------------------------------------------------------------------------+