---------- Forwarded message ----------
From: Gerardo Santana Gómez Garrido <[EMAIL PROTECTED]>
Date: Jun 29, 2005 1:46 PM
Subject: it works, but...
To: [EMAIL PROTECTED]
I'm sending you attached the output of it_works.
DBD::Informix works fine, except that it's taking twice the time than
ESQL/C when I SELECT from a table and do a while($ref = $stmt->fetch)
{ }
This table has aprox. 250 fields and 8000 rows. It takes 199 seconds
for perl to execute the select and fetch all the records, while for
the program in ESQL/C (that selects, fetch, aggregates and prints a
report) it takes 72 seconds.
Any ideas?
--
Gerardo Santana Gómez Garrido
http://www.openbsd.org.mx/santana/
"Entre los individuos, como entre las naciones, el respeto al derecho
ajeno es la paz" -Don Benito Juárez
<WORKING_VERSION VERSION="1.00">
<DBD_INFORMIX> 2005.01 </DBD_INFORMIX>
<DBI> 1.48 </DBI>
<INFORMIX_ESQLC> INFORMIX-ESQL Version 7.24.UC7 </INFORMIX_ESQLC>
<INFORMIX_SERVER> 7.23 (OnLine) </INFORMIX_SERVER>
<PERL> 5.008 PA-RISC2.0 dl_hpux.xs </PERL>
<SYSTEM> hp-ux sech07 b.10.20 b 9000899 629401311 16-user license </SYSTEM>
<SYS_COMPILER> cc </SYS_COMPILER>
<SYS_LOADER> /usr/bin/ld </SYS_LOADER>
<WHEN> 2005-06-29 </WHEN>
<WHO> [EMAIL PROTECTED] </WHO>
<Z_NOTES> It's twice slower than ESQL/C for a SELECT and FETCH on a table with more than 200 fields and 8000 records</Z_NOTES>
</WORKING_VERSION>
