Performance problems with INFORMIX-SE 7.10.UD1
Posted in 1995
Hi informixers! 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 | +-------------------------------------------------------------------------+