Re: DBI & DBD::Pg processor load

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: cgg007(at)yahoo(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: DBI & DBD::Pg processor load
Date: 2003-04-21 14:50:16
Message-ID: 5.2.1.1.1.20030421224846.00b05430@mbox.jaring.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 01:49 AM 4/21/2003 -0700, Chris Gamache wrote:

>Linux 2.4.20 & PostgreSQL 7.2.3 & DBD::Pg 1.22.
>
>I was using PgSQL and PgSQL::Cursor with decent results. It is no
>longer supported, and was causing some strange problems. So, I switched to DBI
>with no problems to speak of. However, I immediately noticed a jump in
>processor usage. I primarily use
>$db->prepare($sql), $rs->execute, and $rs->fetchrow_arrayref.

Not expert, but is it possible to try a plain $rs->fetchrow instead of
fetchrow_arrayref?

Link.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Gamache 2003-04-21 15:12:07 Re: DBI & DBD::Pg processor load
Previous Message greg 2003-04-21 13:53:57 Re: DBI & DBD::Pg processor load