Re: [PHP] Database result set question

2001-04-11 Thread Yasuo Ohgaki
Most PostgreSQL functions are wrapper functions for libpq. Reading documents about libpq will help. Answer to your question is, it does not read all data into memory. I think most DB doesn't do that also. Data will be buffered in PostgreSQL backend, size is depends on your configuration. I'm not

[PHP] Database result set question

2001-04-11 Thread Morgan Curley
Just out of curiosity, can anyone explain the mechanics behind accessing a database query result set. ie $result_id = pg_execute( 'select * from my_table' ); when I call loop through pg_fetch_row( $result_id, $rom_num ) or pg_fetch_object( $result_id, $rom_num ) has php read the entire result s