fastest way to retrieve data

From: Ric Mañalac <ric(dot)manalac(at)webphilippines(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: fastest way to retrieve data
Date: 2002-09-04 03:25:28
Message-ID: 3D757D27.93026D55@webphilippines.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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.

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-09-04 03:41:38 Re: fastest way to retrieve data
Previous Message Christopher Kings-Lynne 2002-09-04 03:23:42 Re: fastest way to retrieve data