From: Chris Gamache <cgg007@yahoo.com>
To: pgsql-interfaces@postgresql.org
Subject: DBD::Pg large processor load.
Date: Fri, 18 Apr 2003 01:29:03 -0700 (PDT)
Message-ID: <20030418082903.61964.qmail@web13807.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: cgg007@yahoo.com
Subject: Re: DBD::Pg large processor load.
In-Reply-To: <20030418082903.61964.qmail@web13807.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox