Re: Bad Performance after Upgrades

Posted in 2000

Isidre PONS ROCA — Wed, 19 Jul 2000 09:24:52 +0200 — source: Informix-list mailing list archive (1991-1998)

En James Skaife va escriure el dia 18 Jul 2000, a les 15:00: > 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 I think you need rebuild your indexes and run update statistics. --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes d'Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------