Loss of performance with IDS 2000
Hi all! 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 ? Thanks a lot in advance Peter -- -------------------------------------------------------- Peter Komanns SINDATA S.p.A. - Italy E-Mail: p.komanns@sindata.it hiroshima 45; chernobyl 86; windows 95 !!!!!!
First and most obvious question: Did you update statistics after upgrade? "Peter Komanns" <p.komanns@sindata.it> wrote in message news:8mn06v$2g81@www.informix.com... > Hi all! > 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 ? > > Thanks a lot in advance > Peter > > -- > -------------------------------------------------------- > Peter Komanns > SINDATA S.p.A. - Italy > E-Mail: p.komanns@sindata.it > > hiroshima 45; chernobyl 86; windows 95 !!!!!! > >
What release(s) of IDS.2000, there are several from 9.20UC1 -> UC4 and 9.21UC2 & UC2. Art S. Kagel Peter Komanns wrote: > > Hi all! > 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 ? > > Thanks a lot in advance > Peter > > -- > -------------------------------------------------------- > Peter Komanns > SINDATA S.p.A. - Italy > E-Mail: p.komanns@sindata.it > > hiroshima 45; chernobyl 86; windows 95 !!!!!!
Hi Peter, We have HP-UX 10.20 and upgraded from IDS 7.30 to IDS2000 with the same problem. I did the UPDATE STATISISTICS as per the other posts but found no improvement. However, I did query analysis and found the cost was HUGE. I changed the query optimizer as follows and performance is now as good, if not better than 7.30 (hard to tell). OPTCOMPIND 0, DIRECTIVES 1, OPT_GOAL -1. Richard Lewis Gerling Global Group of Australia Pty Ltd "Peter Komanns" <p.komanns@sindata.it> wrote in message news:8mn06v$2g81@www.informix.com... > Hi all! > 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 ? > > Thanks a lot in advance > Peter > > -- > -------------------------------------------------------- > Peter Komanns > SINDATA S.p.A. - Italy > E-Mail: p.komanns@sindata.it > > hiroshima 45; chernobyl 86; windows 95 !!!!!! > >