Re: ESQL/C vs I4GL
Posted in 2000
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
From: Carlos Benjamin <benj@linuxstart.com> > >Obnoxio The Clown <obnoxio@hotmail.com> wrote: > > >From: "GDES Urcia Nomberto Luis A." <lurcia@comercio.com.pe> > >> > >> I wolud like to know the advantages of using ESQL/C for UNIX > >>vs I4GL or R4GL. When should i use one or the other? I usually works >with > >>tables of 5 millions of records and it's an OLTP environment. > > > >For data capture/maintenance and reporting, I'd use 4GL any day. For >batch > >processing, the line's more blurred, but I'd probably go for 4GL for ease >of > >maintenance. And I still prefer R4GL over I4GL. > >Would you care to elaborate on that? Your starting to sound like one of the >Oracle twins - all preference and no information. Sheesh. > >I asked awhile back about execution speed between R4GL and I4GL and got no >response. I'd like to hear the whys behind your statements, 'cause I know >you got 'em. In a maintenance form, there's nothing between the two, in a compute-intensive batch or report, I4GL *might* be up to 25% faster. But the main reason for RDS over C4GL is the Interactive Debugger. :) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
And another consideration is the Informix licences you already have. The development and runtime licences (and don't forget support charges) for 4gl are more expensive than for esql. In article <8fgjta$bnu$1@news.xmission.com>, Obnoxio The Clown <obnoxio@hotmail.com> writes > >From: Carlos Benjamin <benj@linuxstart.com> >> >>Obnoxio The Clown <obnoxio@hotmail.com> wrote: >> >> >From: "GDES Urcia Nomberto Luis A." <lurcia@comercio.com.pe> >> >> >> >> I wolud like to know the advantages of using ESQL/C for UNIX >> >>vs I4GL or R4GL. When should i use one or the other? I usually works >>with >> >>tables of 5 millions of records and it's an OLTP environment. >> > >> >For data capture/maintenance and reporting, I'd use 4GL any day. For >>batch >> >processing, the line's more blurred, but I'd probably go for 4GL for ease >>of >> >maintenance. And I still prefer R4GL over I4GL. >> >>Would you care to elaborate on that? Your starting to sound like one of the >>Oracle twins - all preference and no information. Sheesh. >> >>I asked awhile back about execution speed between R4GL and I4GL and got no >>response. I'd like to hear the whys behind your statements, 'cause I know >>you got 'em. > >In a maintenance form, there's nothing between the two, in a >compute-intensive batch or report, I4GL *might* be up to 25% faster. But the >main reason for RDS over C4GL is the Interactive Debugger. :) >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > Andrew Lennard andy@kontron.demon.co.uk