Skip site navigation (1) Skip section navigation (2)

Re: DBD::Pg large processor load.

From: Rudy Lippan <rlippan(at)remotelinux(dot)com>
To: Chris Gamache <cgg007(at)yahoo(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: DBD::Pg large processor load.
Date: 2003-04-21 18:43:23
Message-ID: Pine.LNX.4.44.0304211440000.4221-100000@elfride.ineffable.net (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Fri, 18 Apr 2003, 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. 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?
> 

How much of a processor load are you talking about? Is it a 2%, 20%, 200%
increase in processor usage?

1. Does PgSQL::Cursor uses Cursors?
2. Do you have code that shows the problem?


-r


In response to

Responses

pgsql-interfaces by date

Next:From: riseDate: 2003-04-22 01:21:11
Subject: Re: [INTERFACES] Speed of SSL connections; cost of
Previous:From: Glenn R WilliamsDate: 2003-04-21 18:10:08
Subject: pl/python exceptions.ImportError: No module named _sre

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group