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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
