Re: Online 5.x to 7.x upgrade -Reply

LMARKS@HANYS.ORG wrote: > > I have seen and heard from INFORMIX, similar performance increases > experienced by sites when upgrading to version 7, but in our site it has > been a performance disaster. We have experienced a decline in > performance, in the neighborhood of 100% or worse. So, unless I can > figure something out soon, I will have to rely on an INFORMIX expert to do > on-site consulting for us. Any suggestions or tips would be appreciated. I've found the "update statisitics high/medium" very useful in improving performance. I wrote a small utility that searches the system catalogs and determines the leading index column names, then constructs the proper update statistics high statements. I then run another utility that determines the non-leading columns and updates the statisitics medium. Depending on the version of 7.x that you are using, detached indexes may be a problem. I detached the indexes and put them on separate drives from the data in an early version of 7, and the performance was awful, so I had to attach them to the tables (like in 5.x) and everything was fine again. Good Luck. Mike Reed, mreed@radiix.com