Thanks@xxxxxxxxxxxx wrote: > 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'. George Essig
