Re: dbschema slower in Informix SE 7 than SE 5
From: Evelio Mart'nez <programacionaf@sinix.net>
>
>Obnoxio The Clown wrote:
>
> > From: Evelio Mart'nez <programacionaf@sinix.net>
> > >
> > >I have some scripts that use dbshema and it takes twice the time to
> > >complete on version 7 compare to
> > >version 5.
> > >
> > >Is there any reason for this?
> >
> > Your schema's bigger? :0)
>
>It is the same.
>
> > Seriously, are you not maybe making use of new features or something
>like
> > that?
>
>Basically this 4gl with Informix-4GL 4 and SE 5.10 takes 18 seconds
> with Informix-4GL 7 and SE 7 takes 13
>minutes
>and 33 seconds !!!!!!!!
>
>There are 73 tables.
>The same machine and circumstances (users, bla, bla, ...)
>
>...
> declare c1 cursor for
> select tab,des from tab where mdu = modulo order by des[1,3]>
> foreach c1 into tabla, descrip
> display "Incluyendo Tabla... ", tabla
> let tex =
> "echo display \\\\\\"Creando tabla... ",tabla clipped,"\\\\\\" >>
>u1creamod.4gl"
> run tex
> let tex =
> "$INFORMIXDIR/bin/dbschema -t ",tabla," -d apli >> u1creamod.4gl"
> run tex
> end foreach
> free c1
>...
>
> any idea before cutting my veins?
*I'm* not going to cut your veins. Oh, I see... UPDATE STATISTICS?
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com