DBD::Pg large processor load.

From: Chris Gamache <cgg007(at)yahoo(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: DBD::Pg large processor load.
Date: 2003-04-18 08:29:03
Message-ID: 20030418082903.61964.qmail@web13807.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Linux 2.4.20 & PostgreSQL 7.2.3 & DBD::Pg 1.22.

I was using PgSQL and PgSQL::Cursor with decent results. However, it is no
longer supported, and was causing some problems. So! I switched to DBI. I
immediately noticed a jump in processor usage. I primarily use
$db->prepare($sql), $rs->execute, and $rs->fetchrow_arrayref.

Are there any DBI experts out there with some advice to cut down on processor usage?

__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message jtv 2003-04-20 16:32:44 Re: Getting to learn libpqxx
Previous Message Dave Cramer 2003-04-17 15:19:26 qualified column names