Oninit cdi / Archive
Talk to an expert →

Re: Loss of performance with IDS 2000

Posted in 2000

Topics: Performance & Tuning, SQL Development & Query Writing, Server Administration, Platform-Specific Issues

↪ replying to Obnoxio The Clown
Peter Komanns — — source: Informix-list mailing list archive (1991-1998)

YES! We currently run UPDATE STATISTICS at leat once a day. With IDS 7.31 it was a "no option" command, so a LOW one. With IDS 2000 we first try the same and then grow to HIGH. Specifically, immediately after the upgrade, we run: oncheck -crand, for every DB in the engine: oncheck -cD oncheck -cISQL "update statistics high" Peter -- -------------------------------------------------------- Peter Komanns E-Mail: p.komanns@sindata.it hiroshima 45; chernobyl 86; windows 95 !!!!!! "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:8mn5dg$kp3$1@news.xmission.com... > > From: "Peter Komanns" <p.komanns@sindata.it> > > > >We are massively changing all of our customers' engines from IDS rel. 7.31 > >(on HP-UX 10.20 platform) or IDS rel. 7.30 (on UnixWare 7.1.1 and LINUX > >x86) > >to IDS2000. > >We have verified that in this change there is a real loss of performance > >with exaclty the same programs and the same data and, in some case, the > >query does not come to any response after several hours of running. > >Specificately we have verified very much trouble in handling joins, even > >simple, one-part-unique-key related joins. > >We have tried the fiew options in onconfig file but we did not succeed in > >any way to let the engine do the same as the previous version. > > > >Any hint ? Suggestions ? Experience ? > > UPDATE STATISTICS?> ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >

↪ replying to Peter Komanns
Ty O'Kelly — — source: Informix-list mailing list archive (1991-1998)

Did you run the onchecks after your applications had been accessing the databases? Some testing I did performing an in-place upgrade of a 7.23 database to 9.20 revealed problems with the indexes after the upgrade. I would run oncheck -cID against all the databases and they would appear fine, but after ourapplication had performed some transactions some queries would run forever. Another oncheck would reveal that the table now had corrupted indexes. Perhaps moving from 7.31 to 9.x has the same problem. I hope not... Ty O'Kelly tokelly@maxor.invalid.com Peter Komanns wrote: > YES! > We currently run UPDATE STATISTICS at leat once a day. With IDS 7.31 it was > a "no option" command, so a LOW one. With IDS 2000 we first try the same and > then grow to HIGH. > > Specifically, immediately after the upgrade, we run: > oncheck -cr> and, for every DB in the engine: > oncheck -cD > oncheck -cI> SQL "update statistics high"

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

From: "Peter Komanns" <p.komanns@sindata.it> > >We are massively changing all of our customers' engines from IDS rel. 7.31 >(on HP-UX 10.20 platform) or IDS rel. 7.30 (on UnixWare 7.1.1 and LINUX >x86) >to IDS2000. >We have verified that in this change there is a real loss of performance >with exaclty the same programs and the same data and, in some case, the >query does not come to any response after several hours of running. >Specificately we have verified very much trouble in handling joins, even >simple, one-part-unique-key related joins. >We have tried the fiew options in onconfig file but we did not succeed in >any way to let the engine do the same as the previous version. > >Any hint ? Suggestions ? Experience ? UPDATE STATISTICS?________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Glossary