Re: dbschema slower in Informix SE 7 than SE 5
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?
--
Evelio Mart'nez
Tel: +34 96 337-95-80
Fax: +34 96 337-81-18