Loss of performance with IDS 2000
Peter Komanns
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.ko...@sindata.it
hiroshima 45; chernobyl 86; windows 95 !!!!!!
Doug Agnew
Did you update statistics after upgrade?
"Peter Komanns" <p.ko...@sindata.it> wrote in message
news:8mn06v$2g...@www.informix.com...
Obnoxio The Clown
From: "Peter Komanns" <p.ko...@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
Peter Komanns
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"
Peter
--
--------------------------------------------------------
Peter Komanns
E-Mail: p.ko...@sindata.it
hiroshima 45; chernobyl 86; windows 95 !!!!!!
"Obnoxio The Clown" <obn...@hotmail.com> wrote in message
news:8mn5dg$kp3$1...@news.xmission.com...
Obnoxio The Clown
From: "Doug Agnew" <dag...@charlottepipe.com>
>
>First and most obvious question:
>
>Did you update statistics after upgrade?
Didn't I just say that....? :0)
Ty O'Kelly
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 our
application 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
tok...@maxor.invalid.com
Art S. Kagel
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
Don Ignacio
Hi Peter,
Try to run UPDATE STATISTICS on the newly migrated data.
Don
Richard Lewis
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.ko...@sindata.it> wrote in message
news:8mn06v$2g...@www.informix.com...
smooth1
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.ko...@sindata.it]
>Sent: Monday, August 07, 2000 2:49 PM
>To: inform...@iiug.org
>Subject: Loss of performance with IDS 2000
>
>
Obnoxio The Clown
From: "Peter Komanns" <p.ko...@sindata.it>
>
>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"
It's all coming back to me now, I've really gotta lay off the Diet Coke.
(Aside, I *never* get chicks perving at me when *I* drink a Diet Coke... )-:
Anyway,
UPDATE STATISTICS LOW DROP DISTRIBUTIONS;
Then try your UPDATE STATISTICS again. If that doesn't work, drop and
recreate your indexes.
>--------------------------------------------------------
>Peter Komanns
>E-Mail: p.ko...@sindata.it
>
>hiroshima 45; chernobyl 86; windows 95 !!!!!!
>"Obnoxio The Clown" <obn...@hotmail.com> wrote in message
>news:8mn5dg$kp3$1...@news.xmission.com...
> >
> > From: "Peter Komanns" <p.ko...@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?
Doug Agnew
>
> From: "Doug Agnew" <dag...@charlottepipe.com>
> >
> >First and most obvious question:
> >
> >Did you update statistics after upgrade?
>
> Didn't I just say that....? :0)
>
Obnoxio The Clown
From: "Doug Agnew" <dag...@charlottepipe.com>
>
>"Obnoxio The Clown" <obn...@hotmail.com> wrote in message
>news:8mn8tf$n20$1...@news.xmission.com...
> >
> > From: "Doug Agnew" <dag...@charlottepipe.com>
> > >
> > >First and most obvious question:
> > >
> > >Did you update statistics after upgrade?
> >
> > Didn't I just say that....? :0)
> >
>NOPE --- I GOT THERE FIRST....
Given the number of hours I'm ahead of you... :-)