Oninit cdi / Archive
Talk to an expert →

Re: Bad Performance after Upgrades

Posted in 2000

Topics: Performance & Tuning, Installation, Setup & Upgrades, Server Administration, Platform-Specific Issues

jim lowry — — source: Informix-list mailing list archive (1991-1998)

Just an FYI... You might also want to check your code... 7.31 requires greater useage of PREPARE statements then 7.24 did. > >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 > > Update statistics? > SET EXPLAIN ON shows what?> >-- >David Williams ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

↪ replying to jim lowry
Richard Spitz — — source: Informix-list mailing list archive (1991-1998)

jim lowry schrieb: > You might also want to check your code... > > 7.31 requires greater useage of PREPARE statements > then 7.24 did. Jim, please elaborate on that statement. What code do you mean? 4GL, ESQL/C or what? Why should statements have to be PREPAREd with version 7.31 of the server which worked just fine in 7.24? What could be the case is that Stored Procedures have to be recompiled with the new server version. Regards, Richard -- +-----------------------------+-------------------------------------+ | Dr. med Richard Spitz | Mail: spitz@ana.med.uni-muenchen.de | | Klinik für Anaesthesiologie | Tel : +49-89-7095-6110 | | Klinikum der Univ. München | FAX : +49-89-7095-6420 | | 81366 München, Germany | GSM : +49-172-8933578 | +-----------------------------+-------------------------------------+

Glossary