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@xxxxxxxxxxxxxx > [mailto:pgsql-php-owner@xxxxxxxxxxxxxx]On Behalf Of Ric Mañalac > Sent: Wednesday, 4 September 2002 11:25 AM > To: pgsql-php@xxxxxxxxxxxxxx > 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 >
