Re: SE 5.03 vs 7.2

In <330c0959.1842940@gate.idg.no> Nils.Myklebust@idg.no (Nils Myklebust) writes: >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. You obviously write better code than me. In my last upgrade to SE 7.2, I had quite a few probs with previous bugs (in RDS) that were fixed in 6.0x. One that springs to mind is the handling of AFTER ROW in an INPUT ARRAY (jumped to next row even when a NEXT FIELD was in the clause). The old apps had worked around the problem, and the upgrade broke them. There were a few others like this, but this is all RDS stuff, the engine upgraded as smoothly as a SE[a] breeze. Bryan Tonnet batonnet@zeta.org.au