Skip site navigation (1) Skip section navigation (2)

Re: pg_fetch_array

From: George Essig <george_essig(at)yahoo(dot)com>
To: Thanks(at)verymuch(dot)com
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: pg_fetch_array
Date: 2004-06-21 21:09:21
Message-ID: 20040621210921.47715.qmail@web53702.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-php
Thanks(at)verymuch(dot)com 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

pgsql-php by date

Next:From: Christopher Kings-LynneDate: 2004-06-23 08:33:59
Subject: PostgreSQL guru needed for Enterprise Groupware System
Previous:From: Akshay RajagopalDate: 2004-06-21 18:09:20
Subject: Unsubscribe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group