From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | Ric Mañalac <ric(dot)manalac(at)webphilippines(dot)com>, <pgsql-php(at)postgresql(dot)org> |
Subject: | Re: fastest way to retrieve data |
Date: | 2002-09-04 03:23:42 |
Message-ID: | GNELIHDDFBOCMGBFGEFOIEANCEAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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(at)postgresql(dot)org
> [mailto:pgsql-php-owner(at)postgresql(dot)org]On Behalf Of Ric Mañalac
> Sent: Wednesday, 4 September 2002 11:25 AM
> To: pgsql-php(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ric Mañalac | 2002-09-04 03:25:28 | fastest way to retrieve data |
Previous Message | scott.marlowe | 2002-09-03 17:04:29 | Re: How can I get metadate of a table in PHP3? |