Thanks wrote:

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

Reply via email to