RE: 7.31 performance problem
KT reported performance problems after upgrading from Informix 7.24 to 7.31 on a 20 GB database. Niraj Sinha and Obnoxio The Clown asked whether update statistics had been run; KT said yes. Paulo Amorim said 7.31 had bugs with distributions from medium or high update statistics, and that dropping distributions or rebuilding indexes fixed it for him.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
did u run update statistics etc ??? -----Original Message----- From: kt [mailto:h78816@loisto.uwasa.fi] Sent: Monday, December 18, 2000 7:13 AM To: informix-list@iiug.org Subject: 7.31 performance problem Hi! We changed Informix version from 7.24--->7.31 and after that we have regonised some prformance problems. Our database is about 20Gb. Is there some general things that we haven't regoniced or has anybody had same kind of problems? Thank's in forward KT
Yes! KT > did u run update statistics etc ???
In the year of Our Lord Mon, 18 Dec 2000 20:26:27 +0200, kt <h78816@loisto.uwasa.fi> broke a vow of silence to utter: >Yes! > > >KT > >> did u run update statistics etc ??? So, how about you answer my question?
Does your update statistics command create data distributions ?? This happens if you run update statistcs medium or high. In 7.31 there were some bugs related to these distributions. I solved the problem by dropping the distributions for some tables, and the performance increased. Another attempt is to drop and recreate indexes, it worked in our case too. The problem is that you must analyse the queries that are having problems, identify the tables, then make your actions... and test !!!!! Hope this helps. -- Paulo Roberto Marelli de Amorim TS&0 Consulting Brasil In article <3a3e5d7d.3134757@News.CIS.DFN.DE>, obnoxio@hotmail.com (Obnoxio The Clown) wrote: > In the year of Our Lord Mon, 18 Dec 2000 20:26:27 +0200, kt > <h78816@loisto.uwasa.fi> broke a vow of silence to utter: > > >Yes! > > > > > >KT > > > >> did u run update statistics etc ??? > > So, how about you answer my question? > > Sent via Deja.com http://www.deja.com/