Re: [PERFORM] pg_fetch_array

2004-06-21 Thread Richard Huxton
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

Re: [PERFORM] pg_fetch_array

2004-06-20 Thread Rod Taylor
> 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? You may need to ask the php people about this one. The PostgreSQL protocol would allow data to continue streaming in at the same time as you are pr

[PERFORM] pg_fetch_array

2004-06-20 Thread Thanks
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 data