Re: Informix SE 7 slower than 5 ?

From: Evelio Mart'nez <programacionaf@sinix.net> > >Steven Hauser wrote: > > > Did you run "update statistics" in the recommended way? > >I have tested both. >The recommended way in Informix-SQL sintax guide and also have used a >"macro-report" made by Obnoxio that generates different updates. > > >UPDATE STATISTICS LOW DROP DISTRIBUTIONS; >UPDATE STATISTICS MEDIUM; >UPDATE STATISTICS LOW FOR TABLE dma(alm); >UPDATE STATISTICS LOW FOR TABLE dma(art); >UPDATE STATISTICS LOW FOR TABLE dma(doc); >UPDATE STATISTICS LOW FOR TABLE dma(fec); >UPDATE STATISTICS LOW FOR TABLE dma(lin); >UPDATE STATISTICS LOW FOR TABLE dma(serie); >UPDATE STATISTICS HIGH FOR TABLE dma(alm); >UPDATE STATISTICS HIGH FOR TABLE dma(art); >UPDATE STATISTICS HIGH FOR TABLE dma(fec); >UPDATE STATISTICS HIGH FOR TABLE dma(tma);> > > How about platform, configuration files, etc? > >Is it relevant? Always. Well, sometimes. Can we assume your kernel hasn't changed? >The machine is the same in both cases. SCO OpenServer 5.0.5, 64 Mb >The CPU performs like a 459Mhz Intel Pentium II 64MB? That's a bit small, isn't it? Are you sure you're not swapping? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com