Re: SE 5.03 vs 7.2

Marty McDowell <oshmis1@pacbell.net> wrote: :We are running SE 5.03 and are thinking of moving to SE 7.2 :to get support of DBCENTURY. Is there any hidden gotcha's that :people have run into when upgrading? Are there any new great :features? We have 70 remote sties at ~300mb each we might need :to upgrade. Thanks for any info. We have SE 7.1 at one site, upgraded from 5.x (don't remember the exact version) and we found we had to work a good deal on update statistics (medium and high) for several columns to make the optimiser chose correctly. We did also get rid of an optimiser problem we had in 5.x that lead to long responstimes. The database was about the same size as yours. When you have found the correct update statistics commands to run you should be able to run them on all sites if they have the same databases. Other than this we had no problems. The 4GL programs where a straight recompile with no changes at all. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org