RE: Bad Performance after Upgrades

Posted in 2000

Martin, Wayne E. — Wed, 19 Jul 2000 09:35:21 -0400 — source: Informix-list mailing list archive (1991-1998)

We needed to use in our case: OPTIMIZATION =low then start the engine. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: James Skaife [mailto:skaife@ucar.edu] Sent: Tuesday, July 18, 2000 5:01 PM To: informix-list@iiug.org Subject: Bad Performance after Upgrades 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