Postgres Pro
Downloads
Home   >   mailing lists

DBD::Pg large processor load. - Mailing list pgsql-interfaces

From Chris Gamache
Subject DBD::Pg large processor load.
Date
Msg-id 20030418082903.61964.qmail@web13807.mail.yahoo.com
Whole thread Raw
Responses Re: DBD::Pg large processor load.
List pgsql-interfaces
Tree view 
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

pgsql-interfaces by date:

Previous
From: Dave Cramer
Date:
Subject: qualified column names
Next
From: jtv@xs4all.nl
Date:
Subject: Re: Getting to learn libpqxx