On Sun, Jul 03, 2005 at 03:47:11AM -0500, Gerardo Santana G?mez Garrido wrote:
> ---------- 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?
Can you post the code that's calling the DBI? That's probably where
most of the time is being spent.
A very simple way to check that is to set the DBI_PROFILE env var to 1
before running the script. Let us know what it says.
Tim.
