=?utf-8?B?UkU6IExvc3Mgb2YgcGVyZm9ybWFuY2Ugd2l0aCBJRFMgMjAwMA==?=
Hi Peter, Try to run UPDATE STATISTICS on the newly migrated data. Don -----Original Message----- From: Peter Komanns [mailto:p.komanns@sindata.it] Sent: Monday, August 07, 2000 2:49 PM To: informix-list@iiug.org Subject: 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 !!!!!!
Don Ignacio wrote in message <8mncdt$o9o$1@news.xmission.com>... > >Hi Peter, > >Try to run UPDATE STATISTICS on the newly migrated data. > Go www.iiug.org -> Software and get Art Kagel's utils_ak2 use dostats.ec in there. (You need the Client SDK installed). > >Don > >-----Original Message----- >From: Peter Komanns [mailto:p.komanns@sindata.it] >Sent: Monday, August 07, 2000 2:49 PM >To: informix-list@iiug.org >Subject: 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 !!!!!! >