Re: Bad Performance after Upgrades

One other possibility to check into is a NASTY index buffer feature. If your system has been up for a while, do an onstat -P|tail and look at btree vs. data percentages. If you have the feature, the btree pct will be VERY high -- 90+%. Fixing is simple -- add an environment variable NOLRUPRIO to Informix's. profile and restart your instance. Think it might be fixed in your version, but can't remember. HTH, Doug "James Skaife" <skaife@ucar.edu> wrote in message news:3974C58B.DC6B254B@ucar.edu... > Hi, > We just upgraded from 7.24.UC8 to 7.31.UC6 and from Solaris 2.6 to 2.7. > Since then our queries are taking a lot longer, ie from seconds to > minutes. I used the same values in the 7.31 onconfig file as I had in > the 7.24 onconfig. What am I missing? Any help is GREATLY appreciated! > > James