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
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