Re: DBD versus dblist
Posted in 2003
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration
... I find this quite surprising ... Why? How Perl could be faster that C? Chucho! Jacob Davenport wrote: > I'm a programmer at the US Courts, working on the case management > software that is used by most of the federal criminal, civil, and > bankruptcy courts. > > We use a heavily modified version of dblist, originally written by David > Snyder, to extract data from our Informix databases. It is a compiled c > program using esql libraries. Yesterday, I downloaded DBD::Informix > module and compiled it without a hitch, and it works quite well at > getting data from the database. However, it takes about twice as long > to run as dblist does. When I do my timing test, it is while I am > running Perl, so my script has already compiled. I have tried running > for one row of data, for 60,000 rows of data, for one field, for a 60 > fields, and DBI is always slower. > > I find this quite surprising. My Informix DBA, who is quite sharp, also > finds this surprising. Do you? Do you have any suggestions for us? > > Thanks, > Jacob Davenport > > -- Atte, Jesus Antonio Santos Giraldo ----------------------------------- jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list
Jean Sagi wrote: > ... I find this quite surprising ... > > Why? > > How Perl could be faster that C? It might be running on a faster machine? -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche
"Jean Sagi" <jeansagi@myrealbox.com> wrote in message news:bq0r5t$nai$1@terabinaries.xmission.com... > > ... I find this quite surprising ... > > Why? > > How Perl could be faster that C? It might not be as fast as 'C' but comes pretty close. I can even say that perl DBD will be definitely faster than Java and probably comparable to Informix 4GL speed. Ravi