Remember that looping over a result set doesn't require a 'connection' to
the server, the result is cached in the libpq library space...
Also, building an array will mean it will suck down heaps of extra RAM. I
suggest that you don't actually have a problem, and doing it the way you're
currently doing it is the fastest way.
Chris
> -----Original Message-----
> From: pgsql-php-owner@postgresql.org
> [mailto:pgsql-php-owner@postgresql.org]On Behalf Of Ric Mañalac
> Sent: Wednesday, 4 September 2002 11:25 AM
> To: pgsql-php@postgresql.org
> Subject: [PHP] fastest way to retrieve data
> Importance: High
>
>
> hi,
>
> is there a faster way to retrieve data from postgresql
> using php aside from the conventional way of looping
> through the number of records returned by pg_num_rows
> then executing pg_fetch_row on each iteration? isn't it
> possible to get the entire result set returned by pg_exec
> and save that to a multi-dimensional array? this way
> the program can disconnect from the db and just get
> the data from the multi-dimensional array. this would also
> shorten the number of requests to postgresql.
>
> would appreaciate any suggestions. thanks!
>
> regards,
>
> --
> Ric Mañalac
>
> http://www.webphilippines.com
> http://www.trabaho.com
> http://www.kasal.com
>
> Note:
>
> The information contained in this message may be privileged and
> confidential and protected from disclosure. If the reader of this
> message is not the intended recipient, or an employee or agent
> responsible for delivering this message to the intended recipient, you
> are hereby notified that any dissemination, distribution or copying of
> this communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by replying to
> the message and deleting it from your computer. Thank you.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
