> 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?
The latter - pg_query puts all of the rows in memory. I found this out myself recently. Select a
lot of rows using pg_query without pg_fetch_array. As you're doing this, watch he memory usage
with 'free -s 1'.
pgsql-php by date
|Next:||From: Christopher Kings-Lynne||Date: 2004-06-23 08:33:59|
|Subject: PostgreSQL guru needed for Enterprise Groupware System|
|Previous:||From: Akshay Rajagopal||Date: 2004-06-21 18:09:20|