pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Huxton <dev@archonet.com>
To: Thanks <Thanks@verymuch.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: pg_fetch_array
Date: Mon, 21 Jun 2004 11:34:28 +0100
Message-ID: <40D6B9B4.4000209@archonet.com> (raw)
In-Reply-To: <cajq71$2vku$1@news.hub.org>
References: <cajq71$2vku$1@news.hub.org>

Thanks wrote:
> Hello....
> 
> I would like to know the performance of pg_fetch_array.  Cosider the code:
> 
> $query = "select * from foo";
> $result = pg_query( $db, $query );
> 
> while ($row = pg_fetch_array($result))
> {
>    $a = $row["a"];
>    $b = $row["b"];
>    $c = $row["c"];
>    $d = $row["d"];
> }
> 
> Does php need to read database everytime when pg_fetch_array is executed in
> the while loop or all the rows have been in the memory after pg_query?

Not knowing anything in detail about the PHP drivers, I'm almost certain 
that all rows are returned to PHP and then pg_fetch_array() reads that 
from memory.

> If read database is needed, is there any method to copy all the rows into
> memory by using other command? (because I have a application which needs
> large amount database update/retrieval and I wish the performance of the
> overall applications run faster.)
> 
> or other method you would like to recommend in order to make the faster
> response time?

Are you sure that pg_fetch_array() is the problem? Can you give an 
example of what you're trying to do with the data?

PS - there's a PHP list too.
-- 
   Richard Huxton
   Archonet Ltd



view thread (3+ messages)

Message-ID: <40D6B9B4.4000209@archonet.com>
Permalink:  ../40D6B9B4.4000209@archonet.com/
Also on:    postgresql.org/message-id/40D6B9B4.4000209@archonet.com

 · 

reply

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-performance@postgresql.org
  Cc: dev@archonet.com, Thanks@verymuch.com
  Subject: Re: pg_fetch_array
  In-Reply-To: <40D6B9B4.4000209@archonet.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