Re: Loss of performance with IDS 2000
From: "Peter Komanns" <p.komanns@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.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
> >
>
>
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com