Re: Fwd: it works, but...

On Sun, Jul 03, 2005 at 03:47:11AM -0500, Gerardo Santana G?mez Garrido wrote:
> ---------- Forwarded message ----------
> From: Gerardo Santana G?mez Garrido <gerardo.santana@xxxxxxxxx>
> Date: Jun 29, 2005 1:46 PM
> Subject: it works, but...
> To: dbd.informix@xxxxxxxxx
>
>
> 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.
.

Relevant Pages

  • Re: Smart way to detect SELECT statements?
    ... Of course, when the Admin executes something like UPDATE or DELETE, there is nothing to fetch(), and fetchcomplains loudly. ... The application is designed to work with several database servers, so a database-specific solution won't help me. ... but the DBI documentation is a bit vague about its meaning. ...
    (perl.dbi.users)
  • Re: DBD::CSV and large files...
    ... amonotod wrote: ... "execute for fetch" into DBI which would allow this kind of cursor ...
    (perl.dbi.users)
  • RE: how to fetch all records
    ... The simplest is $dbh->selectrow_arrayref. ... It's documented in the DBI man page. ... how to fetch all records ... Is there another way of fetching all table records in one statement without ...
    (perl.dbi.users)
  • output of the sql querry
    ... The following $sql querry is being executed in the toad well and getting ... While trying to fetch the value through DBI,it outputs the value as I. ...
    (perl.beginners)