Re: Performance problems with INFORMIX-SE 7.10.UD1

: m.mejia@server1.codetel.net.do (Melvin Perez Cedano) writes: : 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? Yes, you are using the compatibility layer sqlrm. On OnLine we have found about a doubling in speed of most programs by simply recompiling them so they connect directly to the database. I would expect the same from SE. I wouldn't expect any significant performance improvement on simple selects moving to SE 7.10, but from what I have seen they have upgraded the query optimiser to use distribution data. In that case you may see a much better performance on selecting joined tables and other more complex selects in that better indexes may be chosen. Until SE 5.0 there where significant problems in this area in some special cases. : 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!! This shouldn't be influenced by sqlrm. It should connect directly and run reasonably fast. : 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!! Nils.Myklebust@ccmail.telemax.no NM-data, Aasesvei 71, 1300 Sandvika, Norway My opinions are those of my company